find out the third highest salary?
Answer Posted / chandiran
select * from (select sal, rownum r from Employee
order by sal desc)
where r=3
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is redo log?
How to filter out duplications in the returning rows using oracle?
How to define a variable to match a table column data type?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How is it different from a normal table?
What is the difference between truncate & delete command?
What is open database communication (odbc) in oracle?
What is rowid and rownum in oracle?
How to lock and unlock a user account in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How do we display rows from the table without duplicates?
What is logical backup in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is define in oracle?
What are the execution control statements?