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
10252 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 union and union all keyword in sql?

1046

Is natural join same as inner join?

945

What is the purpose of the primary key?

1065

Why stored procedure is faster than query?

1063

What programs use sql?

1014

What is oracle sql developer?

1062

What is self-join and what is the requirement of self-join?

1152

What is error ora-01000: maximum open cursors exceeded

1147

What is the function that is used to transfer a pl/sql table log to a database table?

1026

What is a schema? How is it useful in sql servers?

1123

how to calculate expressions with sql statements? : Sql dba

1037

What is pl sql architecture?

964

What is dml with example?

1093

How many types of relationship are there?

1031

When do we use triggers?

1084