如何显示按where子句排序的表中的记录? [英] How to display records from a table ordered as in the where clause?

问题描述

我正在尝试显示记录，如where子句中的顺序. 例如:

I am trying to display the records,order as in the where clause.. example:

select name from table where name in ('Yaksha','Arun','Naveen');

它显示Arun,Naveen,Yaksha (alphabetical order)
我想以相同的顺序显示它i.e 'Yaksha''Arun','Naveen'
如何显示这个... 我正在使用oracle数据库.

It displays Arun,Naveen,Yaksha (alphabetical order)
I want display it as same order i.e 'Yaksha''Arun','Naveen'
how to display this... I am using oracle db.

推荐答案

在查询末尾添加此ORDER BY:

order by case name when 'Yaksha' then 1
                   when 'Arun'   then 2
                   when 'Naveen' then 3
         end

(没有其他方法可以获取该订单.您需要使用ORDER BY才能获取特定的结果集订单.)

(There's no other way to get that order. You need an ORDER BY to get a specific result set order.)

这篇关于如何显示按where子句排序的表中的记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！