Select*from emp Minus Select * from emp Rownum<=(select count (*) -5

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

Question Posted / keshav

Answer Posted / keshav

Select*from emp
Minus
Select * from emp
Rownum<=(select count (*) -5 from emp);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to handle bulk data?

1050

What does pragma mean?

713

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

768

define sql delete statement ? : Sql dba

745

Explain table and field in sql?

780

what happens if you no create privilege in a database? : Sql dba

716

Does sql use python?

756

How to download oracle sql developer?

848

Which type of cursor is used to execute the dml statement?

709

Does sql between include endpoints?

748

What are all types of user defined functions?

736

What is partition in sql query?

719

how to concatenate two character strings? : Sql dba

743

What is the use of sqlerrd 3?

682

Do we need to rebuild index after truncate?

703