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
- 9992 Views
- I also Faced
- E-Mail Answers
Answer Posted / kotesh
select subname,max(marks) from t1 groupby subname
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is set serveroutput on in pl sql?
How do you delete duplicates in sql query using rowid?
What does select * from mean in sql?
What are the uses of merge?
What are types of exception?
What is sql*plus?
How do you define a foreign key?
Can two tables have same primary key?
What plvcmt and plvrb does in pl/sql?
Can a table have no primary key?
What does the sign mean in sql?
How do I count duplicates in sql?
What are the limitations of sql express?
What is scalar function in sql?
What is delimiter sql?
