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

Which one is faster ienumerable or iqueryable?

941

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1069

Explain spool.

1186

what is 'mysqldump'? : Sql dba

1113

How many types of indexes are there in sql?

985

How do you run a query?

995

What are the two characteristics of a primary key?

986

What is program debugging?

1259

How do I turn a list into a table?

963

How do I count rows in sql query?

998

How do you determine the current isolation level? : Transact sql

1163

What are the possible values that can be stored in a boolean data field?

1004

How to display the records between two range in Oracle SQL Plus?

1153

what is myisam? : Sql dba

1090

Explain the difference between triggers and constraints?

981