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
10509 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 alter trigger and drop trigger statements?

1166

Difference between truncate, delete and drop commands?

1145

What is Collation Sensitivity ? What are the various type ?

1006

What are the three forms of normalization?

1096

Can unique keys be null?

949

what is the difference between $message and $$message? : Sql dba

1043

Why do we need databases?

1093

what are different types of collation sensitivity? : Sql dba

1125

What is count * in sql?

1042

What is a sql select statement?

1082

Can a trigger call a stored procedure?

1133

What is compiled query?

1089

Can we commit inside a trigger?

1050

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2272

What is the use of stored procedures?

1112