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
10220 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 null value, zero, and blank space?

1200

How can you save or place your msg in a table?

999

Can we use joins in subquery?

1158

how to use case expression? : Sql dba

1022

Are subqueries faster than joins?

1020

what is an index? : Sql dba

991

Why indexing is needed?

982

Advantages and disadvantages of stored procedure?

1120

What is sql*plus?

1072

What is the mutating table and constraining table?

1026

what is the difference between a web-garden and a web-farm? : Sql dba

1079

What are system versioned tables?

1024

Explain the update statement in sql

983

How to revise and re-run the last sql command?

1163

What is raid? How does it help storage of databases?

1083