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
- 10150 Views
- I also Faced
- E-Mail Answers
Answer Posted / giri babu
select sname,max(smarks)
from t1
group by sname
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how would you get the current date in mysql? : Sql dba
What does select * from mean in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
How do I write a cron which will run a sql query and mail the results to agroup?
What jobs use sql?
What is the difference between an inner join and an outer join?
What are the 3 types of behavioral triggers?
What is the main reason behind using an index?
What is a table?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is difference between rank () row_number () and dense_rank () in sql?
How to run sql commands in sql*plus?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Does view store data in sql?
How many clustered indexes can you have?
