Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anu
select *
FROM (select emp1.* ,rownum rnum
from ( select * from emp order by sal_amount desc ) emp1
where rownum<=3)
where rnum >=3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What types of commands can be executed in sql*plus?
What is user in sql?
What is cross join sql?
how to include comments in sql statements? : Sql dba
Is left join inner or outer by default?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What does fetching a cursor do?
Which table is left in join?
What are the benefits of triggers?
what is offset-fetch filter in tsql? : Transact sql
How do you break a loop in pl sql?
Can we have two clustered index on a table?
Write a sql query to get the third highest salary of an employee from employee_table?
What is the difference between joins?
How do I view stored procedures?
