query help

[arun.xavier50]

iam doing student record project.40 students studying 5 subjects , i want to write sql query to display records of students who scored top 4 marks in each subject.so totaly 20 records to be displayed

[abduraooft]

What you have done so far?

[Old Pedant]

And, more importantly, what is your DB design?

If you only have one table, not at least two tables and probably three or more, then it's a bad design that will only be made worse by trying to do this query.

[JefferyJamison]

Hi ! i don't give you ans because you didn't explain the fields of your Tables. Can you explain it Clearly?

[arun.xavier50]

my database design as follows

student_name subject1_mark subject2_mark subject3_mark subject4_mark subject5_mark

[Old Pedant]

Bad design. Makes it tough to create a good query.

Your only real choice is 5 separate queries, though you could use a UNION to make it *look* like one query.