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

How can check sql version from command line?

1033

What is the use of count (*) in sql?

1004

How to assign sql query results to pl sql variables?

1019

How do I tune a sql query?

953

What is record in pl sql?

1034

What is cursor in pl sql?

1077

Write a query to find the names of users that begin with "um" in sql?

946

How can we optimize a sql query?

1007

Does varchar need length?

950

how to decrement dates by 1 in mysql? : Sql dba

984

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

995

What is the use of primary key?

974

How do I run pl sql in sql developer?

1086

Do foreign keys improve performance?

982

What is crud stand for?

957