How to: list Max tie

[help108]

I have simple question. How to list Max people with tie.

select student.stdname from student, class where (select max(class.awrd) from class) = class.stdnumb and class.stdnumb = student.stdnumb;

Apparently, student table have tie for student total awards they received.
If I run above query it will list only one Max awarded student, but not the other.

How do I list both student with max awards.

[mail2saion]

I can't understand your question clearly but you can try with below modification:

select student.stdname from student, class where class.stdnumb IN (select max(awrd) from class group by stdnumb)  and class.stdnumb = student.stdnumb;