Querying for Data
21 important questions on Querying for Data
What is the syntax of a SELECT statement?
When should you not use * in a SELECT statement?
2. When you want the columns in a different order
What SELECT clause does not support aliases?
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What is the syntax of the BETWEEN operator?
In what order are the rows in a resultset ordered by default?
Does ORDER BY `col`, `col2` DESC sort both columns descending?
Can you specify an ORDER BY statement on the column index, for example ORDER BY 1 ASC, 2 DESC?
Can you use aliases in a MySQL ORDER BY statement?
A temporal column sorted ascending begins with earliest or latest date?
What defines the sort order of binary strings?
What determines the sort order of ENUMs and SETs?
Can you use expressions in a LIMIT statement?
What is the difference between binary and non-binary strings when using the DISTINCT operator?
Non-binary is case-sensitive based on the collation
What is the difference between DISTINCT and a GROUP BY without summarize?
Do the MIN() and MAX() function work on string and temporal fields?
Does COUNT(`col`) include NULL values?
How do you change the separator of GROUP_CONCAT?
How do you change the order of a GROUP_CONCAT?
Why would you add an ORDER BY statement to a GROUP BY statement if the effective ordering is the same?
What does the WITH ROLLUP statement do for a GROUP BY statement?
Does a UNION statement require the tables to have exactly the same structure?
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
![Trustpilot Logo](/images/design_2020/lp/clp-trustpilot-en.png)