What if we are trying to match on a specific text length?
|
|
4
|
5849
|
December 2, 2020
|
With SQL functions, if a parameter is optional, should you still provide a value for it?
|
|
2
|
4227
|
January 28, 2024
|
Does the order we select the columns affect anything?
|
|
8
|
5940
|
January 7, 2023
|
FAQ: Why Data Science? - Exploring Data with SQL
|
|
12
|
4233
|
December 30, 2022
|
What's the difference between GROUP BY and ORDER BY?
|
|
3
|
9804
|
July 14, 2021
|
What's the difference between HAVING and WHERE?
|
|
5
|
6482
|
July 7, 2021
|
Is there another way that determining play counts of a song might have been implemented?
|
|
9
|
3628
|
February 2, 2021
|
Should we always abbreviate column values like for the category column?
|
|
4
|
4892
|
December 4, 2020
|
How can I select data lying within a certain span of time?
|
|
2
|
6859
|
September 13, 2020
|
Does the order of conditions matter if we have more than one in a query?
|
|
2
|
5397
|
July 6, 2020
|
When creating an alias, what's the difference between 'column AS aliasName' and 'column aliasName'?
|
|
2
|
5782
|
February 16, 2020
|
Why isn't there a field for whether a user is premium in the users table?
|
|
0
|
4202
|
December 21, 2018
|
How are database tables separated?
|
|
0
|
4221
|
December 21, 2018
|
FAQ: Manipulation - Insert
|
|
24
|
3835
|
March 27, 2024
|
FAQ: Aggregate Functions - Having
|
|
20
|
2654
|
March 28, 2024
|
FAQ: Window Functions - LAG
|
|
10
|
1100
|
January 25, 2024
|
FAQ: Multiple Tables - Cross Join
|
|
52
|
7399
|
January 25, 2024
|
FAQ: Subqueries - Exists and Not Exists
|
|
9
|
1059
|
January 24, 2024
|
FAQ: Database Normalization with PostgreSQL - Database Structure and Use (Continued)
|
|
5
|
1180
|
July 14, 2023
|
FAQ: PostgreSQL Constraints - PostgreSQL Constraints Review
|
|
9
|
852
|
September 13, 2023
|
Do all table names have to have capital letters?
|
|
8
|
16609
|
March 10, 2022
|
FAQ: Subqueries - Correlated Subqueries II
|
|
8
|
4071
|
March 1, 2022
|
FAQ: First- and Last-Touch Attribution - The Attribution Query II
|
|
17
|
1850
|
February 18, 2022
|
FAQ: Usage Funnels - Build a Funnel from Multiple Tables 4
|
|
52
|
6166
|
December 27, 2021
|
How does the average function work?
|
|
2
|
2753
|
May 24, 2020
|
Can a row be inserted from one table to another?
|
|
0
|
1190
|
December 4, 2018
|
Is DROP TABLE a common action before CREATE TABLE?
|
|
0
|
3702
|
December 3, 2018
|
Are identifiers always numerical values?
|
|
0
|
4174
|
November 22, 2018
|
FAQ: Multiple Tables - With
|
|
34
|
3667
|
March 11, 2024
|
FAQ: Subqueries - Correlated Subqueries I
|
|
14
|
2653
|
March 3, 2024
|