Questions tagged [sql]
For challenges related to structured query language (SQL), including but not limited to short sql code, query result challenges or fixing invalid queries. Note that challenges that require the answers to be in a specific language are generally discouraged.
8 questions
8
votes
6
answers
949
views
Counting the sequences
I was thinking when SQL can be less verbose than traditional programming languages and came up with this challenge.
Input
Natural number N
Generating data
We ...
- 519
1
vote
1
answer
279
views
Most elegant one-liner to generate sqlite INSERTs
Challenge
You find yourself in a bash terminal, and want to do some simple tests
on sqlite3.
So you issue the following command:
...
- 119
7
votes
2
answers
317
views
In as few bytes as possible in t-sql, return 100 rows containing the phrase 'Have a great Christmas'
In as few bytes as possible in t-sql, return 100 rows containing the phrase 'Have a great Christmas'
92 (I think) to beat :D
...
- 89
8
votes
3
answers
726
views
SELECT ALL FROM SelectQL WHERE (answer="short" OR NOT length=10000)
I've invented an SQL-like language. Let's call it SelectQL. You can't INSERT anything, you can only SELECT, and I don't have the ...
- 11.5k
5
votes
1
answer
411
views
What is the longest possible DDL query in PostgreSQL?
We all know and love the corpulent DDL expressions one can write in PostgreSQL with wording like DEFERRABLE INITIALLY DEFERRED, ...
- 211
13
votes
0
answers
624
views
Tips for Golfing in SQLite?
I was looking for this page to help me enhance my first answer with SQLite, but I couldnt find one. So here we are!
What general tips do you have for golfing in SQLite? I'm looking for ideas that can ...
- 2,107
20
votes
10
answers
4k
views
SQL select number ranges
I found it quite hard to achieve a range of numbers as rows in MySQL.
For example the range 1-5 is achieved by:
...
- 353
21
votes
16
answers
7k
views
Tips for Golfing in T-SQL
What general tips do you have for golfing in T-SQL? I'm looking for ideas that can be applied to code golf problems in general that are at least somewhat specific to T-SQL. Please post one tip per ...
- 1,631