query [message #394973] |
Mon, 30 March 2009 23:23  |
gaikwadrachit
Messages: 33 Registered: June 2007 Location: mumbai
|
Member |
|
|
Hi
i have a table emp
emp_no sal grade
1 1000 A
2 2000 B
3 1000 A
I want to select from emp
select * from emp
where emp_no = 1
and sal> 1000;
select * from emp
where emp_no = 2
and sal> 2000;
I want to merge this query without union clause
can anyone help me please??????
|
|
|
|
|
|
|
Re: query [message #394984 is a reply to message #394973] |
Mon, 30 March 2009 23:41  |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>please give the query
Why do you need the query & why do you not produce what you need?
|
|
|