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 / naresh
select subid,max(math),max(phy),max(che) from tablet1
group by subid
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How do you identify a primary key?
What is a file delimiter?
What are the types of queries in sql?
How do you modify a trigger?
what is rollback? : Sql dba
How many types of indexes are there in sql?
What is bulk compiling in pl/sql.?
Why do we use function in pl sql?
What is nosql db?
Does user triggers have entry for trigger with compilation errors?
What is the use of sql trace?
What is the difference between execution of triggers and stored procedures?
What is an oracle stored procedure?
Explain the the delete statements in sql?
How do I partition a table in sql?