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 / kotesh
select sname,max(marks) from student group by sname;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a left join?
What is a boolean in sql?
How do we accept inputs from user during runtime?
What is crud sql?
What is triggering circuit?
What is a join?
what are dynamic queries in t-sql? : Transact sql
Can one improve the performance of sql*loader? : aql loader
what are the advantages of mysql in comparison to oracle? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
What is sql*loader and what is it used for? : aql loader
what does the t-sql command ident_incr does? : Transact sql
What is normalization in sql?
Can a select statement fire a trigger?
Are left and right joins the same?