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

What is primary key and foreign key?

1014

How do you write an inner join query?

996

what is the difference between inner and outer join? Explain with example. : Sql dba

1067

What is a memo field?

1019

How do I truncate a sql log file?

1138

what is bcp? When is it used?

1182

Can you join views in sql?

997

How do I create a sql script?

1143

What is difference between cursor and trigger?

1129

What is varchar data type in sql?

1140

What is use of trigger?

989

How much ram can sql express use?

1042

What is union?

1253

What is #table in sql?

1183

What are the indexing methods?

1099