Thread: select the candidate who have atleast two subjects to appear in exam.?
View Single Post
  #2 (permalink)  
Old 05-21-2007, 11:10 AM
Mohit
 
Posts: n/a
Default ANY answer. Re: select the candidate who have atleast two subjects to appear in exam.?
[sql]Select seat,subject,count(*) from TableName group by seat,subject having count(*)=2[/sql]
Edit/Delete Message Reply With Quote