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
10251 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 I delete a trigger?

968

Is inner join same as self join?

1120

How do I remove duplicates in two columns?

1073

difference between anonymous blocks and sub-programs.

1139

List the various privileges that a user can grant to another user?

1044

what is the difference between blob and text? : Sql dba

1024

State some properties of relational databases?

1058

What is sql indexing?

1014

What is Collation Sensitivity ? What are the various type ?

954

Name the operator which is used in the query for pattern matching?

958

What has stored procedures in sql and how we can use it?

1083

what is 'mysqladmin' in mysql? : Sql dba

1026

What is a constraint? Tell me about its various levels.

1164

Is coalesce faster than isnull?

967

What does count (*) mean?

936