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 you improve the performance of sql*loader? : aql loader
What does joining a thread mean?
what are the different type of sql's statements ? : Sql dba
What is sql*loader and what is it used for? : aql loader
what are the different functions in sorting an array? : Sql dba
What is a composite primary key?
How show all rows in sql?
What is sql and its types?
What is pl sql block structure?
What is #table in sql?
what is online transaction processing (oltp)? : Sql dba
What is the use of index in hive?
Explain about various levels of constraint.
Is there any restriction on the use of union in embedded sql?
What are the types of join in sql?