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

How does rowid help in running a query faster?

1473

Can we perform dml on view?

1114

Which kind of parameters cannot have a default value in pl sql?

1206

What is full join in sql?

1033

what are the different tables present in mysql? : Sql dba

1036

What is a sql select statement?

1082

How to get unique records from a table?

1021

Explain dml and ddl?

1055

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1064

Is sql difficult?

1226

What are database links used for?

1095

What is a clob in sql?

1063

What is the maximum number of columns in sql table?

1226

What are sql queries used for?

1072

how to fetch common records from two tables? : Sql dba

1249