|
About the SQL FAQ category
|
|
0
|
528
|
December 30, 2017
|
|
How do we search for patterns containing the actual characters "%" or "_"?
|
|
8
|
32121
|
April 12, 2021
|
|
Is there a shorter way to insert multiple rows in a table?
|
|
23
|
87216
|
March 12, 2021
|
|
Can a WHERE clause be applied with a HAVING statement in the same query?
|
|
5
|
18329
|
October 29, 2020
|
|
Can we add a column at a specific position to a table?
|
|
16
|
46554
|
May 4, 2021
|
|
When should I use INNER JOIN instead of LEFT JOIN?
|
|
17
|
34032
|
October 15, 2020
|
|
What happens if tables we perform UNION on have duplicate rows?
|
|
12
|
26959
|
April 10, 2021
|
|
What are some ways that SQL is used in data science?
|
|
5
|
63640
|
January 20, 2021
|
|
Does the order of tables in a JOIN matter?
|
|
4
|
22201
|
January 28, 2021
|
|
Can we alias multiple columns in a single query?
|
|
7
|
37203
|
April 17, 2021
|
|
What are some reasons to apply constraints to a table?
|
|
12
|
28814
|
May 5, 2020
|
|
What's the difference between COUNT(1), COUNT(*), and COUNT(column_name)?
|
|
9
|
26409
|
December 7, 2019
|
|
How can we get the average of unique values of a column?
|
|
8
|
21193
|
January 24, 2021
|
|
Can we apply DISTINCT to a SELECT query with multiple columns?
|
|
5
|
83791
|
February 11, 2020
|
|
Can we use WITH for more than one nested query in SQL?
|
|
13
|
12774
|
May 4, 2021
|
|
Does COUNT() include duplicate values of a column?
|
|
15
|
35855
|
April 19, 2021
|
|
How is ALTER different from UPDATE?
|
|
11
|
52712
|
May 4, 2021
|
|
When should we use each type of JOIN?
|
|
1
|
7049
|
November 29, 2020
|
|
When storing missing data, should I store them as NULL?
|
|
12
|
28793
|
April 15, 2021
|
|
When applying the BETWEEN operator on TEXT values, how are values compared?
|
|
3
|
22605
|
July 3, 2020
|
|
Can we apply ORDER BY with multiple columns?
|
|
14
|
26795
|
April 15, 2021
|
|
Are there guidelines to splitting a table as provided in the example?
|
|
9
|
13834
|
April 22, 2021
|
|
When using GROUP BY, do we always have to group by a selected column?
|
|
11
|
20619
|
April 25, 2021
|
|
Can we see a database's schema without being given a diagram?
|
|
0
|
6955
|
November 22, 2018
|
|
Is the `AND` used in `BETWEEN` the same as the `AND` operator between conditions?
|
|
3
|
20595
|
January 18, 2021
|
|
Do SQL clauses always have to be entirely capitalized?
|
|
8
|
33856
|
August 19, 2020
|
|
What if we only want to delete a specific number of rows?
|
|
27
|
38923
|
April 14, 2021
|
|
Where can we access other free datasets?
|
|
1
|
6250
|
July 13, 2020
|
|
Can you CROSS JOIN on more than two tables?
|
|
14
|
12989
|
May 4, 2021
|
|
What happens if we try to create a table with an existing name?
|
|
9
|
38884
|
October 26, 2020
|
