select * from emp where rowid >( select count(*)-n from emp)

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

Question Posted / vikram

Answer Posted / vikram

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

discuss about myisam key cache. : Sql dba

1072

What is cascade in sql?

1017

What is the purpose of cursors in pl/sql?

1206

What is primary key sql?

1113

What is query syntax?

1020

How insert into statements in sql?

1123

What is autocommit sql?

1044

What is denormalization in a database?

1107

Differentiate between sga and pga.

1208

What is right join sql?

1013

What is sqlerrm?

991

Is there a way to automate sql execution from the command-line, batch job or shell script?

1019

How is a PL/SQL code compiled?

1283

Can we rollback after truncate?

1076

What is the command used to fetch the first 5 characters of a string?

1262