diff options
| author | 冯昶 <fengchang@novel-supertv.com> | 2023-12-11 18:11:32 +0800 |
|---|---|---|
| committer | 冯昶 <fengchang@novel-supertv.com> | 2023-12-11 18:11:32 +0800 |
| commit | e94f52525bf99cded9ba76e696b691c7a657500b (patch) | |
| tree | 4e614b7233580b0aee9c58e23e87eff5e9331aee /challenge-246/arne-sommer/sql/ch-1.sql | |
| parent | 4ac02978fd0732a7fcc61a9def95e1e08100e4c9 (diff) | |
| parent | 98df168725aa587bd4db1e24018dae1ca77b29da (diff) | |
| download | perlweeklychallenge-club-e94f52525bf99cded9ba76e696b691c7a657500b.tar.gz perlweeklychallenge-club-e94f52525bf99cded9ba76e696b691c7a657500b.tar.bz2 perlweeklychallenge-club-e94f52525bf99cded9ba76e696b691c7a657500b.zip | |
Merge remote-tracking branch 'upstream/master'
Diffstat (limited to 'challenge-246/arne-sommer/sql/ch-1.sql')
| -rwxr-xr-x | challenge-246/arne-sommer/sql/ch-1.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/challenge-246/arne-sommer/sql/ch-1.sql b/challenge-246/arne-sommer/sql/ch-1.sql new file mode 100755 index 0000000000..fcf1d10e3e --- /dev/null +++ b/challenge-246/arne-sommer/sql/ch-1.sql @@ -0,0 +1,14 @@ +-- sqlite3 -- + +CREATE TABLE lotto (Value INT NOT NULL); + +INSERT INTO lotto VALUES + (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), +(11),(12),(13),(14),(15),(16),(17),(18),(19),(20), +(21),(22),(23),(24),(25),(26),(27),(28),(29),(30), +(31),(32),(33),(34),(35),(36),(37),(38),(39),(40), +(41),(42),(43),(43),(45),(46),(47),(48),(49); + +-- SELECT * FROM lotto ORDER BY RANDOM() LIMIT 6; + +SELECT * FROM ( SELECT * FROM lotto ORDER BY RANDOM() LIMIT 6 ) ORDER BY Value; |