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 use regular expression in pattern match conditions? : Sql dba

1015

Can we have two clustered index on a table?

1011

Can we use distinct and group by together?

1025

Can we write dml inside a function in sql server?

930

What do you know by pl/sql cursors?

1090

Which query operators in sql is used for pattern matching?

940

What is the usage of nvl function?

1025

How does an execution block start and end in pl sql?

927

What are the subsets of sql?

1103

Is sql difficult?

1142

what is the difference between union and union all? : Sql dba

1003

How do I use google cloud in sql?

1069

What is the maximum size of sqlite database?

1090

Can we insert in view in sql?

1037

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

940