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
Answer Posted / kotesh
select sname,max(marks) from student group by sname;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sqlerrm?
What is the maximum database size for sql express?
What is keys and its types?
Which join is default?
What is sql key?
If a cursor is open, how can we find in a pl/sql block?
List the various privileges that a user can grant to another user?
What is the usage of nvl function?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
How do I order by ascending in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
describe transaction-safe table types in mysql : sql dba
Is stored procedure faster than query?
What are the operators used in select statements?