select * from employees minus select * from employees where rownum

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 / arvind kumar

16 Answers
23531 Views
I also Faced
E-Mail Answers

Answer Posted / arvind kumar

select * from employees minus select * from employees where
rownum < (select count(*)-2 from employees);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What types of commands can be executed in sql*plus?

1087

What is sql select statement?

1011

What is foreign key in sql with example?

909

does sql support programming? : Sql dba

1027

Can a select statement fire a trigger?

1136

How do you rename a table in sql?

1084

how can we optimize or increase the speed of a mysql select query? : Sql dba

923

How to use transactions efficiently : transact sql

1030

What is embedded sql with example?

1018

What is dba in sql? : SQL DBA

1024

What is sqlcommand?

1006

What are the two types of exceptions.

1141

Can you select everything, but 1 or 2 fields, without writer's cramp?

967

How do I count rows in sql?

978

How to call a javascript function from pl sql?

1118