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
- 9084 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 are sql ddl commands?
Are subqueries faster than joins?
explain advantages of myisam over innodb? : Sql dba
What is function and procedure in pl sql?
What is sequence in sql?
What is an escape character in sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
Explain the difference between rename and alias?
what are the security recommendations while using mysql? : Sql dba
What is the difference between a procedure and a function?
What is data abstraction in sql?
Is oracle and sql same?
How do I run a script in sql developer?
what are the properties and different types of sub-queries? : Sql dba
What is raw datatype in sql?
