SQL Query
WilliamsOct 18 2010 — edited Oct 21 2010Hi Friends,
I have a table called xxxx and data as follows;
rownum w c name
------------------------------------------------------------
1 999 (null) aaa
2 (null) 222 aaa
3 911 (null) bbb
4 922 (null) bbb
5 (null) 111 bbb
6 933 (null) ccc
7 (null) 333 ddd
8 (null) 444 ddd
My Required o/p as follows;
rownum w c name
--------------------------------------------------------------
1 999 (null) aaa
2 (null) 222 aaa
3 911 (null) bbb
4 922 (null) bbb
5 (null) 111 bbb
Requirement Details are:
=========================
I want to display people who has both 'w and c'.... not just c or w...
from the example, name 'aaa' and bbb has both entries under 'w' and 'c' columns -> want to display these records
where as name ccc and ddd has either entries.... -> omit these records
Regards,
Williams