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

Is sql sequential or random?

995

What does desc stand for?

1037

What are schema-level triggers?

1064

What are types of indexes in sql?

1029

What is consistency?

1080

What are sql procedures?

982

what tools available for managing mysql server? : Sql dba

1035

What are sql functions? Describe the different types of sql functions?

1081

How do you clear the screen in sql?

1029

Differentiate between sga and pga.

1110

What is a clob in sql?

984

How to avoid using cursors?

1061

Can function return multiple values in sql?

1000

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

1026

What is native sql query?

988