KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table like this id title display_order 1 t1 3 2 t2 1 3 t3 5 4 t4 4 5 t5 2 6 t6 0 7 t7 7 8 t8 6 9 t9 0 10 t10 0 What I need is to have results like this id title display_order 2 t2 1 5 t5 2 1 t1 3 4 t4 4 3 t3 5 8 t8 6 7 t7 7 ...order of the rest is not important but should be in the result 6 t6 0 9 t9 0 10 t10 0 I can get this result with two SQL queries and then combine them. Is there a way to do this with one SQL? Thanks
Tags (comma-separated)
Save Edits
Cancel