|
About the SQL FAQ category
|
|
0
|
1191
|
December 30, 2017
|
|
Is there a shorter way to insert multiple rows in a table?
|
|
35
|
198657
|
June 11, 2024
|
|
Can we alias multiple columns in a single query?
|
|
18
|
82932
|
August 13, 2024
|
|
How do we search for patterns containing the actual characters "%" or "_"?
|
|
16
|
58666
|
April 14, 2024
|
|
Can a WHERE clause be applied with a HAVING statement in the same query?
|
|
13
|
39506
|
May 12, 2024
|
|
What are some ways that SQL is used in data science?
|
|
13
|
161180
|
June 10, 2024
|
|
Can we add a column at a specific position to a table?
|
|
22
|
99219
|
June 22, 2024
|
|
When should I use INNER JOIN instead of LEFT JOIN?
|
|
27
|
73960
|
August 21, 2023
|
|
Can we apply DISTINCT to a SELECT query with multiple columns?
|
|
14
|
252737
|
June 26, 2023
|
|
What happens if tables we perform UNION on have duplicate rows?
|
|
22
|
73586
|
August 21, 2023
|
|
Does the order of tables in a JOIN matter?
|
|
10
|
43013
|
September 7, 2024
|
|
How is ALTER different from UPDATE?
|
|
20
|
100754
|
April 23, 2024
|
|
What are some reasons to apply constraints to a table?
|
|
24
|
54905
|
March 14, 2024
|
|
When should we use each type of JOIN?
|
|
1
|
12123
|
November 29, 2020
|
|
How can we get the average of unique values of a column?
|
|
16
|
43534
|
July 31, 2023
|
|
What's the difference between COUNT(1), COUNT(*), and COUNT(column_name)?
|
|
9
|
36333
|
December 7, 2019
|
|
When storing missing data, should I store them as NULL?
|
|
16
|
51019
|
June 29, 2023
|
|
Can we use WITH for more than one nested query in SQL?
|
|
21
|
32652
|
August 21, 2023
|
|
When using GROUP BY, do we always have to group by a selected column?
|
|
19
|
65515
|
August 7, 2023
|
|
Does COUNT() include duplicate values of a column?
|
|
25
|
69233
|
July 25, 2023
|
|
When doing an INNER JOIN, are columns matched on NULL values?
|
|
18
|
45707
|
September 13, 2024
|
|
Are there guidelines to splitting a table as provided in the example?
|
|
17
|
25951
|
August 15, 2024
|
|
Can we apply ORDER BY with multiple columns?
|
|
21
|
55069
|
July 12, 2023
|
|
Are all databases relational?
|
|
6
|
85452
|
December 27, 2023
|
|
Can we apply the LIKE operator to values other than TEXT?
|
|
19
|
73851
|
October 28, 2023
|
|
When applying the BETWEEN operator on TEXT values, how are values compared?
|
|
6
|
39867
|
July 5, 2023
|
|
What are some other useful things that SQL lets us do?
|
|
18
|
23667
|
August 13, 2024
|
|
What if we only want to delete a specific number of rows?
|
|
31
|
75705
|
November 14, 2023
|
|
When using a CASE statement, do the values for THEN have to be a single type?
|
|
37
|
41510
|
July 25, 2023
|
|
Is the `AND` used in `BETWEEN` the same as the `AND` operator between conditions?
|
|
13
|
34995
|
July 7, 2023
|