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 subname,max(marks) from t1 groupby subname
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is vector point function?
What is loop in pl sql?
what is the difference between a web-garden and a web-farm? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Is sql sequential or random?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How to add a column ‘salary’ to a table employee_details?
What is a variable in sql?
How run sql*plus commands that are stored in a local file?
How are functions and procedures called in PL/SQL?
Explain the difference between rename and alias?
Define overloaded procedure?
What is the difference between union and union all command?
What is interval partition?
Is record in oracle pl sql?