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
10253 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

What does stand for in sql?

977

Is hadoop a nosql?

1007

what is view? : Sql dba

970

What is the use of non clustered index?

996

Is null operator in sql?

1044

What are different sql data types?

1051

What is the use of triggers?

1039

Why do we use subquery?

1017

How many joins can you have in sql?

939

Explain aggregate functions are available there in sql?

1011

What are the most important characteristics of pl/sql?

1161

What is the purpose of the primary key?

1065

What is interval partition?

1060

What is sql architecture?

1056

Are stored procedures faster than queries?

948