select *from emp minus select * from emp where rownum <= (select co

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.

Question Posted / ajit nayak

16 Answers
23680 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

Please Help Members By Posting Answers For Below Questions

How many sql databases can you have on one server?

1077

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1009

What is optimistic concurrency control? : Transact sql

981

What are the different types of dbms?

1006

What is the requirement of self-join?

1117

How do you sort in sql?

1013

What are the different tcl commands in sql?

1170

What is pl/sql table? Why is it used?

1030

How do you exit in sql?

1104

Why do we need pl sql?

969

Explain foreign key in sql?

1018

How does postgresql compare to mysql?

1032

Does sql support programming?

1064

How to rename a table?

1010

What can sql server reporting services do?

1105