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

What is primary key secondary key alternate key candidate key?

1037

What are types of indexes in sql?

1082

What are the disadvantages of file system?

1267

how to return query output in html format? : Sql dba

1073

What are database links used for?

1046

How many triggers can be applied to a table?

1063

What is a primary key example?

956

What is the difference between unique and primary key constraints?

1071

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2165

What is union?

1167

What is a table in a database?

1045

What is normalisation in sql?

1053

What is execute immediate?

1084

Explain the methods used to protect source code of pl/sql.

1018

Can %notfound return null after a fetch?

1060