diff options
| author | Abigail <abigail@abigail.be> | 2020-11-09 16:56:37 +0100 |
|---|---|---|
| committer | Abigail <abigail@abigail.be> | 2020-11-09 16:56:37 +0100 |
| commit | 5591cd0982bb00e2b65086947a41b9595a70af71 (patch) | |
| tree | 60dd95fbc3e25ef1a1990d349b3280ff1059bfd8 /challenge-086/abigail/sql | |
| parent | 1f679b09090ef34b292bf56f453aa5531929882f (diff) | |
| download | perlweeklychallenge-club-5591cd0982bb00e2b65086947a41b9595a70af71.tar.gz perlweeklychallenge-club-5591cd0982bb00e2b65086947a41b9595a70af71.tar.bz2 perlweeklychallenge-club-5591cd0982bb00e2b65086947a41b9595a70af71.zip | |
SQL solution for week 86, part 1.
Diffstat (limited to 'challenge-086/abigail/sql')
| -rw-r--r-- | challenge-086/abigail/sql/ch-1.sql | 14 | ||||
| -rw-r--r-- | challenge-086/abigail/sql/ch-1.table | 4 |
2 files changed, 18 insertions, 0 deletions
diff --git a/challenge-086/abigail/sql/ch-1.sql b/challenge-086/abigail/sql/ch-1.sql new file mode 100644 index 0000000000..829d0ca648 --- /dev/null +++ b/challenge-086/abigail/sql/ch-1.sql @@ -0,0 +1,14 @@ +-- +-- For the table definition, see the file ch-1.table +-- +-- The numbers in @N are stored in Numbers, one number per row. +-- The target $A is the value for the place holder in the query. +-- + +SELECT COUNT(*) + FROM (SELECT 1 + FROM Numbers t1, + Numbers t2 + WHERE t1.id != t2.id + AND t1.value - t2.value = ? + LIMIT 1) diff --git a/challenge-086/abigail/sql/ch-1.table b/challenge-086/abigail/sql/ch-1.table new file mode 100644 index 0000000000..02591ce419 --- /dev/null +++ b/challenge-086/abigail/sql/ch-1.table @@ -0,0 +1,4 @@ +CREATE TABLE Numbers ( + id integer PRIMARY KEY, + value integer +); |