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 does ORDER BY 0 mean?
- What does ORDER BY 1 do in MySQL?
- Wat is de UNION-functie in SQL?
- Wat is het verschil tussen UNION en UNION ALL?
- Hoe combineer je twee SELECT-query's in SQL met verschillende kolommen?
- Wat is een UNION-bewerking in een DBMS?
- Hoe gebruik je UNION en UNION ALL in SQL?
- Wat doet UNION SELECT in SQL?