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
- 24171 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 linq to sql?
how to shut down the server with 'mysqladmin'? : Sql dba
Which are the different types of indexes in sql?
What does count (*) mean?
what are numeric data types? : Sql dba
What is difference between group by and partition by?
Why do we use set serveroutput on?
What is the process of debugging?
what are the limitations of identity column? : Transact sql
what is the difference between myisam static and myisam dynamic? : Sql dba
how to convert character strings to dates? : Sql dba
What does bitemporal mean?
What is a relationship and what are they?
explain normalization concept? : Sql dba
What does closing a cursor do?
