Question

sql查询语句怎么样按指定的方式排列

select * from table where (ID=10) or (ID=32) or (ID=22) or (ID=76) or (ID=13) or (ID=44) 让结果按10,32,22,76,13,14的顺序检索出来,如何书写

Answer 1

Select * From Table where id = 10unionSelect * From Table where id = 32unionSelect * From Table where id = 22unionSelect * From Table where id = 76unionSelect * From Table where id = 13unionSelect * From Table where id = 14