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
Who is the owner of mysql database?
what is a trigger in mysql? Define different types of trigger. : Sql dba
Does truncate need commit?
How insert into statements in sql?
How do you use collections in procedure to return the resultset?
List the various privileges that a user can grant to another user?
Why sql query is slow?
How do you modify a column in sql?
Why is sql*loader direct path so fast?
What is difference between my sql and sql?
How can I see all tables in sql?
What is not equal in sql?
What is the most common sql injection tool?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are different functions in sql?