|
Is it good practice to include an id column in every table?
|
|
5
|
27229
|
March 12, 2023
|
|
Does the order we select the columns affect anything?
|
|
8
|
5638
|
January 7, 2023
|
|
FAQ: Why Data Science? - Exploring Data with SQL
|
|
12
|
3894
|
December 30, 2022
|
|
What's the difference between GROUP BY and ORDER BY?
|
|
3
|
9497
|
July 14, 2021
|
|
What's the difference between HAVING and WHERE?
|
|
5
|
6197
|
July 7, 2021
|
|
Is there another way that determining play counts of a song might have been implemented?
|
|
9
|
3416
|
February 2, 2021
|
|
Should we always abbreviate column values like for the category column?
|
|
4
|
4503
|
December 4, 2020
|
|
How can I select data lying within a certain span of time?
|
|
2
|
6674
|
September 13, 2020
|
|
Does the order of conditions matter if we have more than one in a query?
|
|
2
|
5211
|
July 6, 2020
|
|
When creating an alias, what's the difference between 'column AS aliasName' and 'column aliasName'?
|
|
2
|
5533
|
February 16, 2020
|
|
Why isn't there a field for whether a user is premium in the users table?
|
|
0
|
4045
|
December 21, 2018
|
|
How are database tables separated?
|
|
0
|
4086
|
December 21, 2018
|
|
With SQL functions, if a parameter is optional, should you still provide a value for it?
|
|
0
|
3931
|
December 11, 2018
|
|
FAQ: Manipulation - Insert
|
|
20
|
3384
|
April 6, 2023
|
|
FAQ: Subqueries - Exists and Not Exists
|
|
7
|
879
|
August 18, 2023
|
|
FAQ: Aggregate Functions - Having
|
|
17
|
2315
|
August 16, 2023
|
|
FAQ: Multiple Tables - Cross Join
|
|
46
|
6363
|
August 14, 2023
|
|
FAQ: Window Functions - LAG
|
|
8
|
907
|
August 4, 2023
|
|
FAQ: Database Normalization with PostgreSQL - Database Structure and Use (Continued)
|
|
5
|
1025
|
July 14, 2023
|
|
FAQ: PostgreSQL Constraints - PostgreSQL Constraints Review
|
|
9
|
685
|
September 13, 2023
|
|
Do all table names have to have capital letters?
|
|
8
|
15070
|
March 10, 2022
|
|
FAQ: Subqueries - Correlated Subqueries II
|
|
8
|
3702
|
March 1, 2022
|
|
FAQ: First- and Last-Touch Attribution - The Attribution Query II
|
|
17
|
1620
|
February 18, 2022
|
|
FAQ: Usage Funnels - Build a Funnel from Multiple Tables 4
|
|
52
|
5684
|
December 27, 2021
|
|
How does the average function work?
|
|
2
|
2649
|
May 24, 2020
|
|
Can a row be inserted from one table to another?
|
|
0
|
1101
|
December 4, 2018
|
|
Is DROP TABLE a common action before CREATE TABLE?
|
|
0
|
3021
|
December 3, 2018
|
|
Are identifiers always numerical values?
|
|
0
|
4036
|
November 22, 2018
|
|
FAQ: Multiple Tables - With
|
|
28
|
3263
|
September 15, 2023
|
|
FAQ: Why Learn SQL? - Exploring Data with SQL
|
|
16
|
2600
|
August 25, 2023
|