how can we find nth max salary from A table

Answer Posted / venkat

select max(sal) from tablename.

Is This Answer Correct ?    7 Yes 51 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of base tables?

587


Explain in brief how does db2 determine what lock-size to use?

598


How to resolve deadlock issue

17988


Name the lockable units in DB2?

665


What is difference between rollback and commit?

634






What is cascading rollback?

623


What is innodb buffer pool?

564


Give the name of some fields form sqlca.

614


Explain the function done by data manager?

857


What are types of indexes?

593


What is a storage group (stogroup)?

778


How do I optimize a query in db2?

624


Explain about cursor stability?

623


What is runstats db2?

585


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

714