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
- 23762 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
What has stored procedures in sql and how we can use it?
Explain the the update statement in sql?
Is delete faster than truncate?
How do you run a query?
What is sql query limit?
Can you join views in sql?
What is the difference between sql and isql*plus?
What are types of joins?
Does sqlite need a server?
What is the use of triggers?
What is the function that is used to transfer a pl/sql table log to a database table?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Why truncate is used in sql?
what is a join? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
