PL/SQL – select data – group by- having?
I need to select all names where Value EITHER a or b. how do I do that?/thnks
Sample:
Num Name Value
1 Ann a
2 Ann b
3 Julia a
4 Julia b
5 Peter a
6 Jnohn b
Software/Hardware used:
Software/Hardware used:
ASKED:
September 24, 2008 8:23 PM
UPDATED:
September 24, 2008 9:12 PM
Answer Wiki:
You want to use a basic WHERE clause
<pre>SELECT DISTINCT Name
FROM YourTable
WHERE Value IN ('a', 'b')</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
Correction in num column…
I need to select all names where Value EITHER a or b. how do I do that?/thnks
Sample:
Num Name Value
1 Ann a
1 Ann b
2Julia a
2 Julia b
4 Peter a
4Jnohn b