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
- 21387 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit nayak
select *from emp
minus
select *
from emp
where rownum <= (select count(*)-3 from
emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is java sql drivermanager?
Is sql free?
what is transaction? : Sql dba
what does the t-sql command ident_incr does? : Transact sql
Is left join same as join?
What is the primary key?
What is the use of non clustered index?
How to Execute a Package in PL/SQL.?
Should I use mbr or gpt?
What is the size of partition table?
How long it takes to learn pl sql?
Explain exception handling in pl/sql?
What are inbuilt functions in sql?
How can you fetch first 5 characters of the string?
What are sql indexes?
