SQL
'''Structured Query Language''' (SQL) is the ''lingua franca'' for modifying and performing queries in database systems based on Dr. Edgar F. Codd's relational model. (Dr. Codd did not create the SQL language itself.)
SQL has come a long way and it does carry its 30-year-old legacy. But with legacy comes traction and robustness, and up to date, SQL has been the unchallenged means of querying and interoperating with RDBMS.
Some non-RDBMS have even started to adopt SQL-esque languages as their querying interfaces because of the simplicity and expressiveness of SQL.
It is mostly declarative, but each database vendor has extended their dialect of SQL in various incompatible ways to give it more power or to simplify their implementation.
See Also
Tasks
- 100 doors
- A+B
- Arithmetic-geometric mean
- Arithmetic/Integer
- Array length
- Associative array/Creation
- Averages/Arithmetic mean
- Averages/Mode
- Averages/Pythagorean means
- Benford's law
- Birthday problem
- Cartesian product of two or more lists
- Comments
- Conditional structures
- Cumulative standard deviation
- Date format
- Date manipulation
- Day of the week
- Determine if a string is numeric
- Dot product
- Dutch national flag problem
- Even or odd
- Fibonacci sequence
- Filter
- FizzBuzz
- Formatted numeric output
- Forward difference
- Gray code
- Greatest common divisor
- Hamming numbers
- Hash join
- Hello world!
- Hello world/Text
- Hostname
- Integer comparison
- Knapsack problem/0-1
- Last Friday of each month
- Literals/String
- Look-and-say sequence
- MD5
- Matrix multiplication
- Middle three digits
- N'th
- N-queens problem
- Number names
- Palindrome detection
- Parametrized SQL statement
- Playfair cipher
- Primality by trial division
- Repeat a string
- Roman numerals/Encode
- Rot-13
- Run-length encoding
- Set
- Sort an array of composite structures
- Special characters
- String case
- String length
- Sudoku
- Sum of a series
- Sum of squares
- The Twelve Days of Christmas
- Thue-Morse
- Top rank per group
- Zero to the zero power