id name class marks

1 H 1 60
2 H 2 50
3 S 1 70
4 S 2 60
5 V 1 55
6 V 2 80
7 K 1 60
8 K 2 70

This is my table structure.
I want mysql query to get result like

id name class marks

1 S 1 70
2 S 2 60

do you have distinct values? so it can be call easier like status.
mysql query would be like this

SELECT `id`,`name`,`class`,`marks` FROM tbl_name WHERE name='S'