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

Explain what is sql*plus?

1120

Define join and name different types of joins?

987

what is row? : Sql dba

1205

what are ddl statements in mysql? : Sql dba

1173

What is the difference between stored procedure and view?

1007

Enlist the characteristics of pl/sql?

1778

What do you understand by pl/sql packages?

1047

how to run 'mysql' commands from a batch file? : Sql dba

1092

Explain correlated query work?

1039

Can we call dml statement in function?

1026

Is left join faster than inner join?

1105

What are the different types of a subquery?

1031

Explain normalization and what are the advantages of it?

938

What is the difference between python and sql?

972

Can you skip header records while loading? : aql loader

1017