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

What is procedure explain with program?

952

What is the difference between subquery and correlated query?

991

Why are sql stored procedures used?

994

How to return multiple rows from the stored procedure?

916

how to decrement dates by 1 in mysql? : Sql dba

970

Why schema is used in sql?

989

how mysql optimizes distinct? : Sql dba

1002

Do ddl statements need commit?

927

What company owns postgresql?

963

How to avoid duplicate records in a query?

954

What types of commands can be executed in sql*plus?

1051

What are the set operators in sql?

1032

How do you optimize a stored procedure query?

943

What is sql profiling in oracle?

998

Why do we need cursors in pl sql?

1007