What is ORDER BY 1, 2, 3 in SQL?
When using ORDER BY 1, 2, 3 , we're instructing the database to sort the results based on the first, second, and third columns in the SELECT list. ORDER BY 2 DESC , 3 DESC , 1 ASC ; Now, we're instructing the database to group the results based on the second, third, and first column in the SELECT list. Lees verder »
Bron: learnsql.com
Gerelateerd aan What is ORDER BY 1, 2, 3 in SQL?
- What is ORDER BY 2 in SQL?
- What is the correct order of execution of an SQL SELECT statement?
- What is the correct order of SQL?
- What is the default order of ORDER BY in SQL?
- What does ORDER BY 1 2 3 mean in SQL?
- How to find the latest order date in SQL?
- Does SQL ORDER BY ASC or DESC by default?
- What is meant by ORDER BY 2?
- What does ORDER BY 0 mean?
- What does ORDER BY 1 do in MySQL?