I want to know last five transactions or records from emp
table, from now?
Answer Posted / vikram
select * from emp where rowid >( select count(*)-n from emp)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Which data dictionary views have the information on the triggers that are available in the database?
What is sql scripting?
how to enter binary numbers in sql statements? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
How to get list of all tables from a database?
What is Materialized View? In What Scenario we Use Materialized View?
Can we rollback truncate?
What is difference between hql and native sql?
What is trigger and how to use it in sql?
What are the basic sql commands?
difference between anonymous blocks and sub-programs.
What is the maximum number of columns in sql table?
What are pl/sql packages?
What are the most important characteristics of pl/sql?
How can you load multi line records? : aql loader