Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89844 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / ved
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the system predefined user roles?
Explain oracle insert into command?
What is oracle latest version?
What is index in Oracle?
Explain the use of tables option in exp command.
How to use subqueries with the in operator using oracle?
What is the difference between online and offline backups?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the most common interview questions on ETL Testing for experience?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How many file formats are supported to export data?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to delete all rows a table in oracle?
Why cursor variables are easier to use than cursors?
Explain the use of grant option in imp command.
