Interested to Buy Any Domain ? << Click Here >> for more details...
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
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is record in oracle pl sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is a relationship and what are they?
Explain the rollback statement?
How do you delete data from a table?
explain the difference between delete , truncate and drop commands? : Sql dba
What is nested table in pl sql?
What is exception? What are the types of exceptions?
How does join work in sql?
What is bind reference and how can it be created?
How to pipe multiline string to isql?
Does a join table need a primary key?
What mean sql?
What is sql*plus?
