Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151302 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / akshita
select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3
| Is This Answer Correct ? | 43 Yes | 16 No |
Post New Answer View All Answers
What do database buffers contain?
what is port in oracle? how is it related to database application.
How does oracle handle read consistency?
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 and why it is used?
Explain what are clusters?
How to convert raw data type into text in oracle? Explain
How to initialize variables with default values?
What is clustered table in Oracle?
What happens in oracle commit?
Use of an integrity constraint is better to validate data. Explain
What is the difference between sharding and partitioning?
How to create a new oracle data file?
How to loop through a cursor variable?
Explain the use of ignore option in imp command.
