Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 9946 Views
- I also Faced
- E-Mail Answers
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
What is normalisation in sql?
How many sql core licenses do I need?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
Explain the components of sql?
Do we need commit after truncate?
Why do we use partitions in sql?
Is sql similar to python?
What is the difference between left outer join and left join?
Enlist some predefined exceptions?
What is group function in sql?
Which table is left in join?
Which are the different case manipulation functions in sql?
What are two statement types in sql?
How do I partition in sql?
