Answer Posted / sreeharibabu
SELECT id
FROM (select salary2.*, rownum rnum from
(select * from test ORDER BY id DESC) salary2
where rownum <=4)
WHERE rnum >= 4;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql keyword?
What are the three forms of normalization?
Which sql statement is used to delete data from a database?
Does user triggers have entry for trigger with compilation errors?
Explain the rollback statement?
what is meant by urlencode and urldocode? : Sql dba
What is pl sql variable?
Does truncate remove indexes?
what is an extent ? : Sql dba
what is the stuff function and how does it differ from the replace function? : Sql dba
Why do we use view in sql?
What is sql server and ase?
Is subquery faster than join?
What is a dirty read sql?
What is the difference between the conventional and direct path loads? : aql loader