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
- 5993 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
How to export several tables together?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is Undo Management Advisor in Oracle?
What to do if the startbd.bat failed to start the xe instance?
How to apply filtering criteria at group level in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is oracle join syntax?
How to import one table back from a dump file?
How to create a new user account in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to return top 5 rows in oracle?
How to delete an existing row from a table in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
How to create a table in a specific tablespace?
How to load a large xml file?
