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 are character functions in sql?
Can we create table inside stored procedure?
what is 'mysqldump'? : Sql dba
What is the difference between delete and truncate commands?
What are basic techniques of indexing?
Is nosql faster than sql?
What are actual parameters and formal parameters?
What are types of joins?
What is the difference between the implicit and explicit cursors?
Is null operator in sql?
how to create a new table in mysql? : Sql dba
how to convert numeric values to character strings? : Sql dba
What is the non-clustered index in sql?
what are the limitations of identity column? : Transact sql
Are stored procedures faster than dynamic sql?