|
About the SQL FAQ category
|
|
0
|
932
|
December 30, 2017
|
|
Is there a shorter way to insert multiple rows in a table?
|
|
25
|
153169
|
November 30, 2022
|
|
How do we search for patterns containing the actual characters "%" or "_"?
|
|
13
|
43030
|
November 21, 2022
|
|
Can a WHERE clause be applied with a HAVING statement in the same query?
|
|
8
|
25282
|
July 30, 2021
|
|
When should I use INNER JOIN instead of LEFT JOIN?
|
|
24
|
53588
|
August 25, 2022
|
|
What happens if tables we perform UNION on have duplicate rows?
|
|
17
|
51145
|
November 28, 2022
|
|
Can we alias multiple columns in a single query?
|
|
13
|
57483
|
November 22, 2022
|
|
Can we add a column at a specific position to a table?
|
|
16
|
62252
|
May 4, 2021
|
|
What are some ways that SQL is used in data science?
|
|
9
|
103644
|
November 23, 2022
|
|
Does the order of tables in a JOIN matter?
|
|
9
|
30757
|
February 6, 2022
|
|
Can we apply DISTINCT to a SELECT query with multiple columns?
|
|
12
|
173383
|
March 31, 2022
|
|
What are some reasons to apply constraints to a table?
|
|
15
|
39877
|
December 6, 2022
|
|
How is ALTER different from UPDATE?
|
|
13
|
71468
|
November 22, 2022
|
|
What's the difference between COUNT(1), COUNT(*), and COUNT(column_name)?
|
|
9
|
32649
|
December 7, 2019
|
|
How can we get the average of unique values of a column?
|
|
12
|
31251
|
January 9, 2022
|
|
Does COUNT() include duplicate values of a column?
|
|
20
|
51095
|
April 29, 2022
|
|
Can we use WITH for more than one nested query in SQL?
|
|
15
|
18161
|
November 8, 2021
|
|
When storing missing data, should I store them as NULL?
|
|
13
|
38402
|
September 29, 2021
|
|
Is the `AND` used in `BETWEEN` the same as the `AND` operator between conditions?
|
|
6
|
27030
|
December 2, 2022
|
|
When applying the BETWEEN operator on TEXT values, how are values compared?
|
|
4
|
30510
|
October 26, 2022
|
|
When should we use each type of JOIN?
|
|
1
|
9431
|
November 29, 2020
|
|
When using a CASE statement, do the values for THEN have to be a single type?
|
|
22
|
28221
|
December 3, 2022
|
|
What if we only want to delete a specific number of rows?
|
|
29
|
52207
|
February 6, 2022
|
|
Can we apply ORDER BY with multiple columns?
|
|
19
|
36570
|
October 14, 2021
|
|
Can we see a database's schema without being given a diagram?
|
|
0
|
8537
|
November 22, 2018
|
|
Can we apply the LIKE operator to values other than TEXT?
|
|
15
|
51409
|
March 23, 2022
|
|
Is it possible for a table to have more than one unique identifier column?
|
|
16
|
20019
|
February 25, 2022
|
|
Do SQL clauses always have to be entirely capitalized?
|
|
11
|
46546
|
February 11, 2022
|
|
Are there guidelines to splitting a table as provided in the example?
|
|
12
|
19692
|
January 29, 2022
|
|
When doing an INNER JOIN, are columns matched on NULL values?
|
|
13
|
25874
|
August 4, 2021
|