Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153809 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / husenaiah.b
select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal
| Is This Answer Correct ? | 22 Yes | 38 No |
Post New Answer View All Answers
What are the advantages of oracle 12c?
How to update a table row with a record?
How to rename an index in oracle?
What is the difference between substr and instr?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to create an initialization parameter file?
State and explain the different types of data models?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is an oracle?
Explain the use of ignore option in imp command.
What privilege is needed for a user to create tables in oracle?
How to bring a tablespace online?
Can you assign multiple query result rows to a variable?
How to start instance with a minimal initialization parameter file?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
