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
- 23186 Views
- I also Faced
- E-Mail Answers
Answer Posted / ammu
Hi Prakash Kumar,
this is the problem with rownum. In general never use = or
> with rownum. I will explain the reason.
Siuppose u hav 2 rowns in a table.
when u say select * from emp where rownum =2.
then 2 row will get selected ...but as soon as it gets
selected..since it is the only row in the selection its row
num will change to 1.
so this will return 0 rows.
similarly..
when u say rownum >1
2 row will get selected but as soon as it get selected its
rownum changes to 1.. so no rows selected again
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to delete an existing column in a table? : Sql dba
What is the use of sqlerrd 3?
What is the difference between microsoft access and sql server?
List the different type of joins?
what does the t-sql command ident_incr does? : Transact sql
What is a sql statement?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is sql*plus?
What does joining a thread mean?
How do you modify a column in sql?
how to get a list of indexes of an existing table? : Sql dba
what is the use of double ampersand (&&) in sql queries?
How many triggers can be applied on a table?
What are instead of triggers?
What do you understand by exception handling in pl/sql?
