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
- 10137 Views
- I also Faced
- E-Mail Answers
Answer Posted / dharmendra
select subject,max(marks) from table_name
group by subject
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of non clustered index?
What is the mutating table and constraining table?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
what is the difference between truncate and drop statements? : Sql dba
How to read xml file in oracle pl sql?
How do I save the results of sql query in a file?
What is insert command in sql?
What is sql*loader?
How would you reference column values before and after you have inserted and deleted triggers?
What is difference between rank () row_number () and dense_rank () in sql?
What are the subsets of sql?
What does stand for in sql?
what are the join types in tsql? : Transact sql
What are the datatypes available in pl/sql ?
Why trigger is used in sql?
