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 do I find sql profiler?

992

Is sql database free?

1025

What are sql queries used for?

1079

What will you get by the cursor attribute sql%notfound?

1129

How does cross join work?

1008

What can you do with pl sql?

1143

Can we change the table name in sql?

1001

What are tables and fields in the database?

1188

How do you delete duplicates in sql query using rowid?

989

What programs use sql?

1087

Does truncate require commit?

1033

what is oracle database ? : Sql dba

1080

how do you tune the slow running queries in oracle db , explain the methodology

3230

what is meant by nl2br()? : Sql dba

1107

what are the advantages of sql ? : Sql dba

1106