select sname,max(mark) from xtable group by sname; che 56 mat 40 phy

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

8 Answers
10018 Views
I also Faced
E-Mail Answers

Answer Posted / kart

select sname,max(mark) from xtable group by sname;
che 56
mat 40
phy 33

Is This Answer Correct ?

14 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do we need to check in database testing?

980

What is pl sql block in dbms?

975

what is transaction? : Sql dba

975

How do I partition in sql?

920

What is rollback?

1067

Can we use views in stored procedure?

998

Is sqlite good enough for production?

970

How do I run pl sql in sql developer?

1086

What are sql triggers used for?

974

Why use subqueries instead of joins?

1049

what tools available for managing mysql server? : Sql dba

1035

What is synonyms?

1014

What is the use of sqlerrd 3?

912

how to show all tables with 'mysql'? : Sql dba

1076

What types of commands can be executed in sql*plus?

1077