FAQ   SQL FAQ


Topic Replies Activity
Is there a shorter way to insert multiple rows in a table? 16 December 18, 2019
When applying the BETWEEN operator on TEXT values, how are values compared? 1 August 4, 2018
What if we are trying to match on a specific text length? 1 November 22, 2018
When using a CASE statement, do the values for THEN have to be a single type? 9 November 25, 2019
Can we write conditions using both AND and OR? 6 November 28, 2019
FAQ: Subqueries - Non-Correlated Subqueries III 9 November 1, 2019
How does the average function work? 1 December 11, 2018
What's the difference between HAVING and WHERE? 4 October 1, 2019
FAQ: Subqueries - Correlated Subqueries I 9 October 21, 2019
What's the difference between GROUP BY and ORDER BY? 1 December 6, 2018
What does strftime() do? 1 December 21, 2018
When creating an alias, what's the difference between 'column AS aliasName' and 'column aliasName'? 2 June 12, 2019
Does the order we select the columns affect anything? 1 December 21, 2018
Are 0 and "" empty values? 1 November 22, 2018
Why isn't there a field for whether a user is premium in the users table? 1 December 21, 2018
What do the numbers refer to in a statement like 'GROUP BY 1' or 'ORDER BY 2'? 5 September 24, 2019
What's the difference between COUNT(1), COUNT(*), and COUNT(column_name)? 10 December 7, 2019
Does casing matter when selecting the names? 5 September 23, 2019
FAQ: Manipulation - Relational Databases 1 October 25, 2018
Are identifiers always numerical values? 1 November 22, 2018
How are database tables separated? 1 December 21, 2018
Are all databases relational? 3 September 17, 2019
Given a value that is not a unique identifier, can we determine a unique identifier? 1 August 24, 2018
Does making a "mini" dataset actually create a new table? 1 December 21, 2018
Is there another way that determining play counts of a song might have been implemented? 4 September 4, 2019
Does every SQL statement follow this structure? 3 August 17, 2019
Do we have to select the column which we are ordering by in a SQL statement? 1 November 16, 2018
Are we limited to only one aggregate function per query? 1 August 4, 2018
FAQ: Code Challenge: Multiple Tables - Code Challenge 6 7 November 5, 2019
Are there guidelines to splitting a table as provided in the example? 4 September 24, 2019