select subid,max(math),max(phy),max(che) from tablet1 group by subid

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

8 Answers
10136 Views
I also Faced
E-Mail Answers

Answer Posted / naresh

select subid,max(math),max(phy),max(che) from tablet1
group by subid

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between subquery and correlated query?

1042

how to analyze tables with 'mysqlcheck'? : Sql dba

995

How many commands are in sql?

1050

What is a trigger word?

1001

Which one is better subquery or joins?

1039

what is the use of friend function? : Sql dba

1009

What is dml statement?

937

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

956

What is user in sql?

1002

Is oracel sql developer written in java?

1088

What is secondary key?

917

How do I remove duplicates in two columns?

1030

Whis is not false in primary key?

1442

Define a temp table?

1002

What are types of joins?

947