select * from emp minus(selecet * from emp where rownum<(select count(*

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

Question Posted / thulasi reddy

Answer Posted / thulasi reddy

select * from emp minus(selecet * from emp where
rownum<(select count(*)_4 from emp))

this will give last records

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is substitution variable?

1001

What is varchar used for?

1023

What does inner join mean?

1061

Which is better cte or subquery?

970

What happens when a trigger is associated to a view?

840

Define SQL and state the differences between SQL and other conventional programming Languages?

1141

What is use of term?

1008

What are aggregate and scalar functions?

974

What are the packages in pl sql?

966

what are the differences between char and varchar? : Sql dba

1002

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

947

How does one use sql*loader to load images, sound clips and documents? : aql loader

1117

What is sql basics?

991

How do I edit a stored procedure?

946

What are the 3 types of behavioral triggers?

1182