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

What is the clause we need to add in function body to return variable?

987

Is it possible to pass parameters to triggers?

1055

what is meant by urlencode and urldocode? : Sql dba

1114

How do you create an update query?

931

Is it possible to update views?

933

how to calculate the difference between two dates? : Sql dba

1019

How is debugging done?

939

Can we group by two columns in sql?

952

What is an exception in PL/SQL? What are the two types of exceptions?

1228

What is difference between stored procedure and trigger?

1089

Explain the the delete statements in sql?

1011

How does sql store data?

879

How do I run a sql trace?

927

What is dense_rank in sql?

933

What is count * in sql?

963