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
10496 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 is the advantage of nosql?

1115

How many types of relationship are there?

1085

How many sql are there?

1053

What is db journal file?

1158

What is record type in pl sql?

1036

How is a process of pl/sql compiled?

1243

Explain mutating table error.

1264

What is schema in sql?

1003

what is online transaction processing (oltp)? : Sql dba

1040

What is sql constant?

1104

What are types of exception?

963

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1086

What is a temporal table?

983

What schema means?

940

What is blind sql injection?

1169