Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118814 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / niladri saha
into my above solution,u can get whatever position u want,only by giving "n" at the place of "2" at row num. That the right way to write the query. That u can use in dynamically.
Thanks,
like if ur require ment to print empnames of having 3rd max salary,then put 3 at rownum.
Niladri Saha.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of the partition table?
What is null in pl/sql?
What are sql functions? Describe the different types of sql functions?
what is innodb? : Sql dba
How do I view stored procedures?
Explain what is rdbms?
Enlist some predefined exceptions?
What is a sql*loader control file?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How to pipe multiline string to isql?
Explain the difference between sql and mysql.
What are all types of user defined functions?
How is data stored on a disk?
Is it possible to pass parameters to triggers?
What is varchar used for?
