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

How to run sql statements through the web interface?

1020

What's the difference between inner join and left join?

984

what is the syntax used for partition in tsql? : Transact sql

996

what are the t string functions available in tsql? : Transact sql

990

what is uncommittable transactions? : Transact sql

986

what are myisam tables? : Sql dba

1014

Why do we need view in sql?

968

Is join an inner join?

946

Why is sql important?

1086

Is clustered index a primary key?

931

How do I remove sql plus from windows 10?

1075

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

973

What is inner join in sql?

1058

how to load data files into tables with 'mysqlimport'? : Sql dba

1078

What is latest version of sql?

1027