我有下表
id | parent | question
---------------------------------
1 | 0 | Question 1
2 | 0 | Question 2
3 | 2 | SubQuestion 2
4 | 0 | Question 3
5 | 2 | SubQuestion 2
我如何选择列问题,以便将其排序为这样的:
Question 1
Question 2
Subquestion 2
Subquestion 2
Question 3
有办法吗?
Order by case when parent = 0 then id else parent end, id
小提琴