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
Answer Posted / sumit
select subject,max(marks) from t1 group by subject;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is restrict in sql?
What does stand for in sql?
How do you update a table in sql?
What can you do with pl sql?
What is the difference between an inner join and an outer join?
What is the purpose of a secondary key?
How do I find duplicates in sql?
what are the 'mysql' command line options? : Sql dba
What is clustered index in sql?
How do I add a database to sql?
What is cursor and its types?
how to use 'mysql' to run sql statements? : Sql dba
What is pl/sql table? Why is it used?
What is sql partition?
How do I find duplicates in a single column in sql?