|
Does casing matter when selecting the names?
|
|
6
|
7298
|
January 30, 2021
|
|
What if we are trying to match on a specific text length?
|
|
4
|
6003
|
December 2, 2020
|
|
How are database tables separated?
|
|
0
|
4359
|
December 21, 2018
|
|
Does the order we select the columns affect anything?
|
|
8
|
6341
|
January 7, 2023
|
|
What's the difference between GROUP BY and ORDER BY?
|
|
3
|
10034
|
July 14, 2021
|
|
Is there another way that determining play counts of a song might have been implemented?
|
|
9
|
3861
|
February 2, 2021
|
|
Should we always abbreviate column values like for the category column?
|
|
4
|
5197
|
December 4, 2020
|
|
How can I select data lying within a certain span of time?
|
|
2
|
7053
|
September 13, 2020
|
|
Does the order of conditions matter if we have more than one in a query?
|
|
2
|
5545
|
July 6, 2020
|
|
When creating an alias, what's the difference between 'column AS aliasName' and 'column aliasName'?
|
|
2
|
5968
|
February 16, 2020
|
|
Why isn't there a field for whether a user is premium in the users table?
|
|
0
|
4363
|
December 21, 2018
|
|
FAQ: Subqueries - Exists and Not Exists
|
|
10
|
1291
|
September 6, 2024
|
|
FAQ: Why Data Science? - Exploring Data with SQL
|
|
13
|
4450
|
June 13, 2024
|
|
FAQ: Manipulation - Insert
|
|
24
|
4190
|
March 27, 2024
|
|
What's the difference between HAVING and WHERE?
|
|
5
|
6829
|
July 7, 2021
|
|
FAQ: Window Functions - LAG
|
|
11
|
1260
|
July 2, 2024
|
|
FAQ: Aggregate Functions - Having
|
|
20
|
2937
|
March 28, 2024
|
|
FAQ: Multiple Tables - Cross Join
|
|
52
|
8177
|
January 25, 2024
|
|
FAQ: Database Normalization with PostgreSQL - Database Structure and Use (Continued)
|
|
5
|
1301
|
July 14, 2023
|
|
FAQ: PostgreSQL Constraints - PostgreSQL Constraints Review
|
|
9
|
997
|
September 13, 2023
|
|
Do all table names have to have capital letters?
|
|
8
|
18058
|
March 10, 2022
|
|
FAQ: First- and Last-Touch Attribution - The Attribution Query II
|
|
17
|
2080
|
February 18, 2022
|
|
FAQ: Usage Funnels - Build a Funnel from Multiple Tables 4
|
|
52
|
6574
|
December 27, 2021
|
|
How does the average function work?
|
|
2
|
2845
|
May 24, 2020
|
|
Can a row be inserted from one table to another?
|
|
0
|
1222
|
December 4, 2018
|
|
Is DROP TABLE a common action before CREATE TABLE?
|
|
0
|
4341
|
December 3, 2018
|
|
Are identifiers always numerical values?
|
|
0
|
4310
|
November 22, 2018
|
|
Do we have to select the column which we are ordering by in a SQL statement?
|
|
0
|
4213
|
November 16, 2018
|
|
FAQ: Queries - Case
|
|
42
|
3221
|
September 18, 2024
|
|
FAQ: Multiple Tables - With
|
|
36
|
4011
|
June 5, 2024
|