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

Explain architecture of sql server notification services?

1036

What does stand for in sql?

951

What version is sql?

1005

Explain unique key in sql.

988

What is procedure and function in sql?

971

Does truncate table reset auto increment?

977

Is ms sql is free?

1007

What are crud methods?

1014

Why do we use function in pl sql?

1044

What is sap sql?

960

What do we need to check in database testing?

1002

Explain the select statement in sql?

1094

What is sp_helptext?

1051

What is cursor and its types?

1047

How can you create an empty table from an existing table?

1057