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
- 10243 Views
- I also Faced
- E-Mail Answers
Answer Posted / naresh
select subid,max(math),max(phy),max(che) from tablet1
group by subid
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
how to decrement dates by 1 in mysql? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is union and union all keyword in sql and what are their differences?
Does normalization improve performance?
What is case function?
What is synonyms?
When do we use triggers?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Which nosql database is best?
How do you write a complex sql query?
What found sql?
What is set transaction?
What are sql built in functions?
How can triggers be used for the table auditing?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
