按顺序显示值
it1352
帮助1人
问题说明
我有一个查询
i have a query
"select * from details where id=7 or id=3 or id=11 or id=9"
在执行此查询时，我需要这样的结果集.
while executing this query i need a result set like this.
Id Name<br />
<br />
7 Ammu<br />
3 Jithu<br />
11 yana<br />
9 Achu<br />
How is it possible.? Can anyone help me?正确答案
#1
尝试一下.
Try this.
select * from details where id IN (7, 3, 1) order by id desc
或
or
select * from details where id=7 or id=3 or id=1 order by id desc我得到了解决方案.解决方案是
i got the solution.. solution is
"select * from details where id=7 union all select * from details where id=3 union all select * from details where id=11 union all select * from details where id=9"这篇好文章是转载于：学新通技术网
