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
- 23528 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil bisht
Hi Prakash,
You did one mistake in this query when you are use rownum
is always start fetch the record from very first record
from table
Row num can work only with the follow using operators
=(only with 1)(select * from emp where rownum=1;) if you
are use 2 or other number in place of 1 so result is no
data found;
<(any vlaue)(select * from emp where rownum<12 if you are
using the > sign in place of < sign so result is no data
found
<=(any value)
Between 1 and any value
>=(only with 1)
<>(any value) this will return all records less than the
given value
if you want to retrive last three records from table then
you can used
select * from emp where rownum<=(select count(*) from emp)
minus select *from emp where rownum <=(select count(*)-3
from emp)
you get the last three record from the table
other method is
select * from emp e where 3>(select count(*) from emp d
where d.rowid>e.rowid);
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What does select top 1 do in sql?
How do I create an index in word?
Is not null in sql?
how can we know the count/number of elements of an array? : Sql dba
what is table? : Sql dba
what are the different type of normalization? : Sql dba
What are the different set operators available in sql?
Why do we need sharding?
What does bitemporal mean?
how mysql optimizes distinct? : Sql dba
What is a full join sql?
What are the topics in pl sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What type of join is sql join?
Does truncate release storage space?
