An SQL interview question not started today

Select the highest score for each subject

 

Lisng language 80
Nonly language 78
Jiang mathematics 88
Lxy math 80
Jacky foreign language 99

Andy math 66

 

Select B. stu_id, stu_name, A. Course, A. Score
From
(Select Course, max (score) as score from stu_info group by course) As,
Stu_info as B

Where B. Course = A. Course and B. Score = A. Score

 

Only

Chinese

Mathematics

Foreign Language

Score should be a group, so Max is used to get the maximum value.

 

Stronger

 

Select * From stu_info as
Where score = (select max (score) from stu_info where course = A. Course)