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 / 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
Can pl sql procedure have a return statement?
What are the types of variable use in pl sql?
Why do we use procedures in sql?
How to use transactions efficiently : transact sql
what is the command used to fetch first 5 characters of the string? : Sql dba
How insert into statements in sql?
Is stored procedure faster than query?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What does select count (*) mean in sql?
Which one is better subquery or joins?
What is clustered index in sql?
What is full join in sql?
How much ram can sql express use?
Name the operator which is used in the query for pattern matching?
Why schema is used in sql?