select sname,max(marks) from student group by sname;

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

8 Answers
10134 Views
I also Faced
E-Mail Answers

Answer Posted / kotesh

select sname,max(marks) from student group by sname;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

explain what is mysql? : Sql dba

1064

what is clause? : Sql dba

1049

Define sql delete statement.

986

how to include comments in sql statements? : Sql dba

937

what are all the common sql function? : Sql dba

1041

What schema means?

874

Does mysql_real_escape_string prevent sql injection?

934

Explain the types of joins in sql?

1014

Which is better stored procedure or query?

948

What is a null value?

1124

Which is the correct statement about truncate and delete?

1087

What is not null in sql?

1032

Is sql database free?

957

Define overloaded procedure?

1055

How long will it take to learn pl sql?

920