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

How to pronounce postgresql?

1057

how to drop an existing view in mysql? : Sql dba

1060

what are rollup and cube in t-sql? : Transact sql

1095

Explain the purpose of %type and %rowtype data types with the example?

994

what is a trigger in mysql? : Sql dba

1146

what is text? : Sql dba

1069

What is the purpose of design view?

1005

How does stored procedure reduce network traffic?

1007

What makes a good primary key?

1037

What are the different types of sql commands?

1126

Can we write ddl statements in functions?

1116

What is the difference between subquery and correlated query?

1065

Does sql*plus have a pl/sql engine?

1069

What is trigger with example?

1097

How do you change a value in sql?

1019