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
10004 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 are the parameter modes supported by pl/sql?

1039

Why is sql better than hql?

938

The select into statement is most often used to create backup copies of tables or for archiving records?

1030

What is offset in sql query?

1085

How many types of normalization are there?

920

What is rank dense_rank and partition in sql?

989

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1135

Which is better varchar or nvarchar?

946

What are the packages in pl sql?

985

How delete a row in sql?

948

What is cursor and its types?

1024

Explain what is a field in a database and record in a database?

1035

What does sign mean sql?

1042

what is 'mysqladmin' in mysql? : Sql dba

987

What is embedded sql what are its advantages?

984