Sql result b where condition

Поиск
Список
Период
Сортировка
От ramasubramanian
Тема Sql result b where condition
Дата
Msg-id C4A7A9FD054F4922BF24B03489A3F2FE@ramasubramanian
обсуждение исходный текст
Ответ на Dynamic sql example  ("ramasubramanian" <ramasubramanian.g@renaissance-it.com>)
Ответы Re: Sql result b where condition
Список pgsql-performance
Hi all,
    I have a table emp. using where condition can i get the result
prioritized.
Take the example below.

select ENAME,ORIG_SALARY from employee where (ename='Tom' and
orig_salary=2413)or(orig_salary=1234 )

if the fist condition(ename='Tom' and orig_salary=2413) is satified then 10
rows will be returned, for the second condition (orig_salary=1234 ) there
are 20 rows will be returned.
The order of display should be

The first 10 rows then
next 20 rows.
Thanks & Regards,
Ram



В списке pgsql-performance по дате отправления: