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 is ORDER BY 1, 2, 3 in SQL?
- What does ORDER BY 1 do in MySQL?
- What is meant by ORDER BY 2?
- What does ORDER BY 1 mean?
- What does ORDER BY DESC mean?
- What is ORDER BY 2 in SQL?
- Hoe kan ik een zakelijke order annuleren?
- What is the correct order of execution of an SQL SELECT statement?
- What is the default order of ASC and DESC?
- What is the correct order of SQL?