SELECT student_code, name
FROM students
WHERE marks =
(SELECT MAX(marks)
FROM students
GROUP BY subject_code);
pls suggest me for this
i am stuck here
Search found 1 match
- Sat Jun 25, 2016 7:47 am
- Forum: Database Related
- Topic: What’s wrong in the following query?
- Replies: 3
- Views: 16601