Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147693 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / selvaraj anna university coe
In ORACLE 10g,
SELECT * FROM employee x WHERE 3 = (SELECT COUNT(DISTINCT
salary)
FROM employee y WHERE x.salary <= y.salary);
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
How do you tell what your machine name is and what is its IP address?
How to save query output to a local file?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Is truncate autocommit in oracle?
What are the advantages of oracle 12c?
What are the differences between lov and list item?
Difference between inner join vs where ?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is a select query statement in oracle?
Explain integrity constraint?
How a database is related to tablespaces?
How to filter out duplications in the returning rows using oracle?
How can we find out the duplicate values in an oracle table?
