Querry performance [message #360113] |
Wed, 19 November 2008 11:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sreenu80
Messages: 50 Registered: July 2006 Location: bangalore
|
Member |
![srinivas_ch_05%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi Friends,
I have a senario like this
select decode(name,'smith','Manager','N/A') from emp where
deptno = 10
union
select decode(name,'smith','Accotent','N/A') from emp where deptno = 10
I need to pick these two records in one single select statement. I mean with out union condition.
Please let me know.
thanks
sreenu
|
|
|
|
|
|
|
Re: Querry performance [message #360163 is a reply to message #360146] |
Wed, 19 November 2008 22:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Michel Cadot wrote on Wed, 19 November 2008 20:35 |
In the end, post a representative test case: create table and insert statements along with the result you want with these data and explain this result.
Regards
Michel
|
|
|
|