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
10499 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 a null value?

1191

What are character functions in sql?

996

Explain 3 basic parts of a trigger.

1376

What is number function in sql?

1018

Can a table have no primary key?

1113

Does sql view stored data?

1003

Why is sql*loader direct path so fast?

1142

How to select all records from the table?

1183

Is stored procedure faster than query?

1022

Can we call stored procedure in function?

1004

What is a data definition language?

1198

What are different types of queries in sql?

1178

What is the use of function "module procedure" in pl/sql?

1241

What is a left join?

1009

What is difference between my sql and sql?

1140