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
9939 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 sqlerrm?

883

What is the maximum database size for sql express?

962

What is keys and its types?

1022

Which join is default?

899

What is sql key?

924

If a cursor is open, how can we find in a pl/sql block?

1105

List the various privileges that a user can grant to another user?

990

What is the usage of nvl function?

985

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

957

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2111

How do I order by ascending in sql?

958

what is the command used to fetch first 5 characters of the string? : Sql dba

1587

describe transaction-safe table types in mysql : sql dba

946

Is stored procedure faster than query?

916

What are the operators used in select statements?

1002