On Mon, 25 Jan 2010, A. Kretschmer wrote:
> In response to ramasubramanian :
> Please, create a new mail for a new topic and don't hijack other
Even more so - this isn't probably the right mailing list for generic sql
>> 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.
> select ENAME,ORIG_SALARY, 1 as my_order from employee where (ename='Tom' and
> orig_salary=2413) union all select ENAME,ORIG_SALARY, 2 employee where
> (orig_salary=1234 ) order by my_order.
select ENAME,ORIG_SALARY from employee where (ename='Tom' and
orig_salary=2413)or(orig_salary=1234 ) ORDER BY orig_salary DESC
as there is going to be only two values for orig_salary.
The early bird gets the worm. If you want something else for breakfast, get
In response to
pgsql-performance by date
|Next:||From: A. Kretschmer||Date: 2010-01-25 12:24:00|
|Subject: Re: Sql result b where condition|
|Previous:||From: Matthew Wakeling||Date: 2010-01-25 11:59:41|
|Subject: Re: Data Set Growth causing 26+hour runtime, on what we
believe to be very simple SQL|