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
23656 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 is normalisation in sql?

1049

Can ddl statements be used in pl/sql?

1136

Can we use rowid as primary key?

981

what is the functionality of the function htmlentities? : Sql dba

944

What are sql data types?

1013

What are all the common sql functions?

1007

Explain the advantages and disadvantages of stored procedure?

1137

what is online transaction processing (oltp)? : Sql dba

991

What are the topics in pl sql?

967

what is msql? : Sql dba

981

What is the purpose of normalization?

1038

Are stored procedures faster than queries?

943

Is sqlite good enough for production?

990

What is the best partition size for windows 10?

995

Is sql developer case sensitive?

987