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
10141 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 are the limitations of identity column? : Transact sql

1087

what is 'mysqld'? : Sql dba

956

Are subqueries faster than joins?

992

Why is sql better than hql?

970

How to write pl sql program in mysql command prompt?

1068

What is difference between pl and sql?

1034

What is rownum in sql?

1007

what is the difference between undefined value and null value? : Sql dba

1077

Why do we use sql constraints?

1153

Is it important to partition hard disk?

1004

What are aggregate and scalar functions?

1002

What is sqlite format?

1172

What is the difference between sql, mysql and sql server?

1067

What is sqlca in powerbuilder?

993

What is partition by in sql?

1048