select sname,max(marks) from student group by sname;

i have a table t1 a math 20
b phy 30
cchemisty 10
a math 40
b phy 23
c che 21
a math15
bphy 33
c che 56
write a quire to find out the max markr of each subject

Question Posted / kotesh

8 Answers
10249 Views
I also Faced
E-Mail Answers

Answer Posted / kotesh

select sname,max(marks) from student group by sname;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why is a trigger used?

945

where are cookies actually stored on the hard disk? : Sql dba

1030

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1028

what happens if null values are involved in expressions? : Sql dba

1045

Which command is used to delete a package?

1177

Is sql difficult?

1162

Can %notfound return null after a fetch?

1062

What is offset and limit in sql?

1062

what are the type of locks ? : Sql dba

966

What is %s in sql?

1032

How many postgresql users are there, worldwide?

1065

What is trigger and types?

1030

How to return an array from java to pl/sql?

1144

What is union?

1174

What is mdf ldf and ndf?

1002