Search found 1 match

by malisha21
Sat Jun 25, 2016 7:47 am
Forum: Database Related
Topic: What’s wrong in the following query?
Replies: 3
Views: 1779

What’s wrong in the following query?

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