how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / sunil panghal
select rownum as row_id,salary from (select salary from
employees order by salary) where rownum <6;
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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?
Explain index?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Why is oracle used?
How to connect ms access to oracle servers?
What are the oracle differences between nvl and coalesce
Explain the use of analyse option in exp command.
What is tns entry?
Explain an index segment?
What are the parameters that we can pass through a stored procedure?
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?
How to define and use table alias names in oracle?
What is catalog in Oracle?
How do I know if oracle is installed on windows?
Can you have more than one content canvas view attached with a window ?