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

Which sql statement is used to delete data from a database?

463

What is the difference between left and left outer join?

513

What are database links used for?

591

What is a variable in sql?

511

what is 'trigger' in sql? : Sql dba

555

Can dml statements be used in pl/sql?

573

What is a system versioned table?

527

what are string data types? : Sql dba

510

Is join same as left join?

526

What is mutating sql table?

604

What is interval partition?

541

Mention what is the function that is used to transfer a pl/sql table log to a database table?

484

How many scalar data types are supported in pl/sql?

518

What are triggers and its uses?

593

How can you load multi line records? : aql loader

655