select subject,max(marks) from t1 group by subject;

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 / sumit

8 Answers
10138 Views
I also Faced
E-Mail Answers

Answer Posted / sumit

select subject,max(marks) from t1 group by subject;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you delete a table?

1053

What is trigger types of trigger?

1047

what is csv? : Sql dba

982

What is the difference between partition and index?

966

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

973

What are the indexing methods?

1026

what is top in tsql? : Transact sql

1086

Does postgresql run on the cloud?

1127

what is the difference between join and union? : Sql dba

1089

Are stored procedures compiled?

898

What is data abstraction in sql?

1009

Is there a way to automate sql execution from the command-line, batch job or shell script?

953

What are analytic functions in sql?

1007

Can we enter data in a table in design view?

951

explain primary keys and auto increment fields in mysql : sql dba

948