Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 41460 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
select sal from( select rownum,e.* from empmaster e order
by sal desc) where rownum < 4
| Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
Which join condition can be specified using on clause?
What is normalization? How many normalization forms are there?
Explain how to use transactions efficiently : transact sql
Define overloaded procedure?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How do I add a database to sql?
explain access control lists. : Sql dba
Can a table have no primary key?
What is execute immediate?
what is the difference between truncate and drop statements? : Sql dba
How do you create a unique index?
What is java sql package?
How can you load microsoft excel data into oracle? : aql loader
What is trigger in pl sql?
What is scope of pl sql developer in future?
