FAQ   SQL FAQ


Topic Replies Activity
What does a CROSS JOIN do? 3 April 4, 2020
What are some other useful things that SQL lets us do? 7 December 11, 2019
Are there guidelines to splitting a table as provided in the example? 5 March 27, 2020
What happens if tables we perform UNION on have duplicate rows? 6 April 3, 2020
Do SQL clauses always have to be entirely capitalized? 5 February 21, 2020
Can we see a database's schema without being given a diagram? 1 November 22, 2018
How is ALTER different from UPDATE? 4 March 16, 2020
Are all databases relational? 3 September 17, 2019
Does every SQL statement follow this structure? 3 August 17, 2019
When storing missing data, should I store them as NULL? 8 February 16, 2020
What if we set a LIMIT value that is greater than the total number of rows? 3 February 10, 2020
What happens if we try to create a table with an existing name? 7 January 11, 2020
Should we always abbreviate column values like for the category column? 4 December 25, 2019
When using a CASE statement, do the values for THEN have to be a single type? 9 November 25, 2019
Does the ROUND() function round up? 22 April 3, 2020
Does the order we select the columns affect anything? 1 December 21, 2018
What does strftime() do? 1 December 21, 2018
Are 0 and "" empty values? 1 November 22, 2018
What's the difference between GROUP BY and ORDER BY? 1 December 6, 2018
Does the order of conditions matter if we have more than one in a query? 1 November 16, 2018
What if we are trying to match on a specific text length? 1 November 22, 2018
Do the tables have to have the same number of columns when combining them? 2 February 21, 2020
When creating an alias, what's the difference between 'column AS aliasName' and 'column aliasName'? 3 February 16, 2020
If multiple rows have the minimum or maximum value, which one is returned when using MAX/MIN? 3 June 2, 2019
FAQ: Aggregate Functions - Having 11 October 18, 2019
FAQ: Subqueries - Correlated Subqueries II 8 October 7, 2019
FAQ: Queries - Case 14 January 27, 2020
Can we apply DISTINCT to a SELECT query with multiple columns? 6 February 11, 2020
FAQ: Subqueries - Non-Correlated Subqueries III 9 November 1, 2019
FAQ: Subqueries - Correlated Subqueries I 9 October 21, 2019