select max(math)max(phy),max(che) from t1

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

8 Answers
10239 Views
I also Faced
E-Mail Answers

Answer Posted / satishilluri

select max(math)max(phy),max(che) from t1

Is This Answer Correct ?

9 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the advantage of index in sql?

971

What does partition by mean in sql?

962

What is dynamic sql in pl sql?

1034

What are tuples in sql?

1135

How do you modify a column in sql?

997

What is full join in sql?

991

How would you reference column values before and after you have inserted and deleted triggers?

1065

what is the syntax for using sql_variant_property? : Transact sql

1044

What is interval partition?

1054

What is sql used for?

1124

Does varchar need length?

992

What is a left join?

954

Can you selectively load only those records that you need? : aql loader

1048

What are the uses of sysdate and user keywords?

1104

How to use boolean type in select statement?

1074