Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 40643 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / saisravanthi
select salary from
(select salary,rownum from salary_tab
order by salary_tab desc)
where rownum < 4;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is cross join sql?
what is self-join? : Sql dba
What are analytical functions in sql?
where are cookies actually stored on the hard disk? : Sql dba
What are sql functions? Describe in brief different types of sql functions?
How many joins can you have in sql?
How do you identify a primary key?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is a database trigger?
What is the difference between numeric and autonumber?
What is not equal in sql?
Show the two pl/sql cursor exceptions.
Which is faster union or join?
how to get @@error and @@rowcount at the same time? : Sql dba
