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

Can function return multiple values in sql?

990

Define union, minus, union all, intersect ?

951

Write a sql query to convert all character to uppercase after hypen.

1381

What is sql and explain its components?

1009

Can we create a trigger on view?

845

How many sql statements are used?

967

what is blob? : Sql dba

1059

what is an index? : Sql dba

936

Explain constraints in sql?

986

What are the ddl commands?

953

Does truncate table reset auto increment?

941

How can I tell if sql is running?

999

What are the types of join in sql?

1032

How many clustered indexes can you have?

929

Is vs as in pl sql?

935