Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve last tree records from table?
select *from emp where rownum > (select count(*)-3 from
emp);
i am using this query to get last three records from table
but its not giving any output, so please tell me what is the
error in this query.
- 16 Answers
- 23575 Views
- I also Faced
- E-Mail Answers
Answer Posted / pavithra
select * from emp where rowid in(select rowid from emp
where rownum<=&upto minus select rowid from emp where
rownum<&start)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is uncommittable transactions? : Transact sql
Is vs as in pl sql?
How can we find duplicate records in a table?
Write a sql query to find the names of employees that begin with ‘a’?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is cursor status?
What is having clause in sql?
what is sql in mysql? : Sql dba
Why is the cursor important?
Can we use pl sql in mysql?
What is the difference between the implicit and explicit cursors?
Mention what is the plv (pl/vision) package offers?
What is oracle pl sql developer?
Differentiate pl/sql and sql?
Does view store data in sql?
