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 mdb stand for?

958

What do you mean by rowid?

911

What is a Mapplet?

1057

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

897

What are the three forms of normalization?

992

what is 'mysqlimport'? : Sql dba

973

what are the drivers in mysql? : Sql dba

981

what are the differences between require and include, include_once and require_once? : Sql dba

966

what is a field in a database ? : Sql dba

986

What is procedure function?

981

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1057

What is the difference between union and union all command?

1006

How many times can we commit in a loop?

955

explain advantages of innodb over myisam. : Sql dba

1082

What is delimiter sql?

920