Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary in a given table????
- 5 Answers
- 8708 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh
SELECT *
FROM (SELECT ROWNUM sl, salary
FROM (SELECT DISTINCT salary
FROM employees
ORDER BY salary))
WHERE sl = n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to update a table row with a record?
how to make an oracle object
What is a tns file?
What are the data types in oracle?
What is a package in oracle?
What is flashback in Oracle?
What are the ansi data types supported in oracle?
Explain about the analyze command in oracle?
How to generate query output in html format?
How to create a new view in oracle?
What are triggers in oracle?
query optmization techniques and quwry analyser+projects+ppts
What is a subquery?
What is analyze command used for?
