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
23755 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

Does sql backup shrink transaction log?

979

Why we use triggers in mysql?

992

Explain what is table in a database?

1057

How do I create an index in word?

1032

Is sql a case sensitive language?

946

What is indexing in sql and its types?

1080

how to do backup entire database? : Transact sql

1144

What are the different set operators available in sql?

1026

What does desc stand for?

1069

what is a database lock ? : Sql dba

1169

Is time a data type in sql?

906

What are the possible values that can be stored in a boolean data field?

1000

Which query operators in sql is used for pattern matching?

966

Is crud a cuss word?

1033

How do you declare a constant?

960