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
9944 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 is the difference between join and natural join?

885

how many triggers are allowed in mysql table? : Sql dba

997

What is a sql driver?

943

what is online transaction processing (oltp)? : Sql dba

938

What is flag in sql?

989

Define join and name different types of joins?

962

How delete all records from table in sql?

930

What is pl sql in oracle?

992

What is prepared statement in sql?

1000

What is the difference between numeric and autonumber?

942

What are the 3 types of behavioral triggers?

1188

What is difference between joins and union?

1050

What do you mean by rowid?

917

What is the use of non clustered index?

930

How do I create a sql database?

951