select the candidate who have atleast two subjects to appear in exam.?

#1 (**permalink**) 03-27-2007, 08:24 PM

i need to find out the students fm the database which has a records of seat no and subjects code.and so for one seat no there's a maximum six subject. problems is how to find out all the students who has just the two subjects or two subjects code corresponding to the seat no.

#2 (**permalink**) 05-21-2007, 11:10 AM

SELECT seat,subject,count(*) FROM TableName GROUP BY seat,subject HAVING count(*)=2

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

User Name		Remember Me?
Password

vBulletin Message

Cancel Changes

select the candidate who have atleast two subjects to appear in exam.?

ANSWER(S):