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
- 10497 Views
- I also Faced
- E-Mail Answers
Answer Posted / sumit
select subject,max(marks) from t1 group by subject;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 database sql?
how many groups of data types? : Sql dba
What is the purpose of a secondary key?
What do we need to check in database testing?
What is the non-clustered index in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is difference between pls_integer and integer?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
what is auto increment? : Sql dba
What is a record in pl/sql?
How to write pl sql program in mysql command prompt?
what is heap table? : Sql dba
What is an escape character in sql?
