select * from emp minus(selecet * from emp where rownum<(select count(*

I want to know last five transactions or records from emp
table, from now?

Question Posted / thulasi reddy

Answer Posted / thulasi reddy

select * from emp minus(selecet * from emp where
rownum<(select count(*)_4 from emp))

this will give last records

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to run sql*plus commands in sql developer?

1133

Can a foreign key be null?

1069

What is the difference between alter trigger and drop trigger statements?

1092

What is a sql*loader control file?

1232

What is varchar example?

1013

How exception is different from error?

1003

What are different types of tables in sql?

978

how to write date and time literals? : Sql dba

946

How to order siblings in oracle hierarchy queries?

1022

Why are cursors used?

1105

What is primary key secondary key alternate key candidate key?

1017

What is a heap in sql?

1047

How do I remove all records from a table?

1062

Can we write ddl statements in functions?

1095

What is Difference Between Unique and Primary Key Constraints?

1094