select subname,max(marks) from t1 groupby subname

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
10231 Views
I also Faced
E-Mail Answers

Answer Posted / kotesh

select subname,max(marks) from t1 groupby subname

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does a covering index work?

958

How do you respond to dementia behavior?

967

What is %type in pl sql?

966

Which is faster view or stored procedure?

944

how to show all tables with 'mysql'? : Sql dba

1118

What is difference between joins and union?

1124

what is difference between delete and truncate commands? : Sql dba

1131

What is nosql example?

1034

What does select * from mean in sql?

3235

What is the sql query to display the current date?

1044

Why does sql need a server?

1037

What is pivot in sql?

912

what is a join? : Sql dba

1034

What is orm in sql?

1046

What is scalar function?

1051