select sname,max(smarks) from t1 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 / giri babu

8 Answers
9935 Views
I also Faced
E-Mail Answers

Answer Posted / giri babu

select sname,max(smarks)
from t1
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 do I add a database to sql?

1062

Write a unique difference between a function and a stored procedure.

924

Why do we need pl sql?

934

How do you identify a primary key?

1010

What is a database? Explain

1050

What if we write return in procedure?

1333

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

1003

Can a foreign key be null?

1029

Does sql full backup truncate logs?

965

Does db2 use sql?

889

What are % type and % rowtype?

979

How do you write a complex sql query?

1007

What can sql server reporting services do?

1054

Explain mutating table error.

1130

What is normalization? How many normalization forms are there?

1010