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 is the picture clause of null indicator variable?

688


How do I import a csv file into db2?

558


What is the use of predicate?

580


What is the role of data manager in the db2 database?

640


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

644






What is the maximum size of a char data type in db2?

585


What db2 400?

675


How can you quickly find out the # of rows updated after an update statement?

630


What do you mean by cursor?

580


Define db2 and its databases?

618


What is explain plan in db2?

586


What is null indicator in cobol db2?

580


Explain db2.

611


What is a bind card?

679


Can there be more than one cursor open for any program?

657