Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQLPlus ==> How do I rewrite this Query ?
My SQLPlus query (on Oracle 8.1.7) is
SELECT EVAL, HD13
FROM MY_TABLE
GROUP BY EVAL, HD13
/
which returns the below :-
EVAL HD13 ----- ----- QDOS ABC AII ABC QDOS XYZ AII PQR QDOS PQR QDOS AAA AII BBB
Question:-
How can the query be rewritten to list out
only rows 1,2,4,5 ie rows with both QDOS and AII for any single HD13
(note only possible values for EVAL is either QDOS or AII)
Thanks in advance Received on Tue Jan 14 2003 - 07:54:38 CST
![]() |
![]() |