What does ORDER BY 0 mean?
The order statement generates a 'virtual field' that contains NULL or 0 based on the case condition. The ORDER BY is applied based on that virtual field. The zero value in the order by precedes the NULL value. That's all, it's a way to set NULLs of the field1 at the end of the order list. Lees verder ยป
Bron: dba.stackexchange.com
Gerelateerd aan 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?
- Wat betekent != in SQL?