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 / kart
select sname,max(mark) from xtable group by sname;
che 56
mat 40
phy 33
Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What is the difference among union, minus and intersect?
explain normalization concept? : Sql dba
Does access use sql?
What is a pl/sql block?
What is the difference between inner join and outer join?
What is sql deadlock?
How much does a sql dba make? : SQL DBA
Is oracel sql developer written in java?
What is rank () in sql?
What is sql table?
Is sql a backend language?
What is forward declaration in pl sql?
what is a trigger? : Sql dba
What are the types pl/sql code blocks?
Why partition by is used in sql?