KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Currently, I am doing a very basic OrderBy in my statement. SELECT * FROM tablename WHERE visible=1 ORDER BY position ASC, id DESC The problem with this is that NULL entries for 'position' are treated as 0. Therefore, all entries with position as NULL appear before those with 1,2,3,4. For example, NULL, NULL, NULL, 1, 2, 3, 4 Is there a way to achieve the following ordering? 1, 2, 3, 4, NULL, NULL, NULL.
Tags (comma-separated)
Save Edits
Cancel