Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
- 3 Answers
- 6185 Views
- I also Faced
- E-Mail Answers
Answer Posted / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a data lock in oracle?
Is postgres faster than oracle?
How to define a specific record type?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to get a list of all background sessions in the database?
Explain how you would restore a database using RMAN to Point in Time?
Query to retrieve record for a many to many relationship ?
What is the relationship among database, tablespace and data file?
How to connect to a local oracle 10g xe server?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is oracle update statement with inner join ?
How to connect asp pages to oracle servers?
Will you be able to store pictures in the database?
What is hash cluster in oracle?
How to open and close an explicit cursor in oracle?
