April 2nd, 2009, 07:01 PM
Join Date: Apr 2009
Time spent in forums: 21 m 43 sec
Reputation Power: 0
Originally Posted by allasyed
i have one table students
In this i want a record who are the students participating in both football and hockey only.
Result is raju is the only person participatin in football and hockey.
i want oracle query for this condition.
pls anyone help me
SELECT DISTINCT stud_name where part_sport in ('football', 'hockey')
SELECT DISTINCT stud_name where part_sport = 'football' or part_sport = 'hockey'