Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20411 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / dhanya
select rnk, no,sal from (
SELECT DENSE_rank()over(partition by no order by sal desc ) RNK,d2.no,sal FROM DUMMY2 d2)
where rnk =2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How can we create the complete backup of data in the oracle.
How to write a query with an inner join in oracle?
How to invoke the original export import utilities?
Explain the use of indexes option in exp command.
How do I connect to oracle?
Explain the use of log option in exp command.
How to do clean up if create database failed?
what is Single Byte Overhead...?
How to convert csv to table in oracle?
Can the query output be sorted by multiple columns in oracle?
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 the difference between postgresql and oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
