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 / satishilluri
select max(math)max(phy),max(che) from t1
Is This Answer Correct ? | 9 Yes | 12 No |
Post New Answer View All Answers
What is a full join sql?
Which constraints we can use while creating database in sql?
What is composite data type in pl sql?
What are joins in sql?
What is bulk collect in pl sql?
How can I make sql query run faster?
What are the different sql commands?
What is cursor status?
Can we join more than 2 tables in sql?
What is acid property in a database?
How do I create a sql script?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Is sql difficult?
What are the differences between implicit and explicit cursors?
What are inner and outer joins examples of both?