find out the second highest salary?
Answer Posted / yaseen syed
select *
from
(select empno,ename,sal,rank() over(order by sal desc)
ranking from emp)
where ranking=2;
and u can find the nth highest sal by replacing 2 by your
number
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the advantages of oracle 12c?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is save point in oracle database?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are the various types of snapshots ?
What are the different types of synonyms?
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.
What is Reduced List of Values?
What is an anonymous block?
Why do we need integrity constraints in a database?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What do you mean by redo log file mirroring?
How to drop an existing view in oracle?
How to specify default values in insert statement using oracle?