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 foreign key in sql with example?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is sap sql?
How to get unique records from a table?
Which is faster union or join?
What can you do with pl sql?
What is the difference between a primary key and a clustered index?
Why do we use joins?
how to select unique records from a table? : Sql dba
What is the use of sqlerrd 3?
What are the sql aggregate functions?
How many triggers can be applied on a table?
how to return query output in html format? : Sql dba
What is the usage of when clause in trigger?
Why is the cursor important?