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


Please Help Members By Posting Answers For Below Questions

What is the best sql course?

530


How do I count rows in sql?

555


how to decrement dates by 1 in mysql? : Sql dba

578


Where is sql database stored?

514


What packages are available to pl/sql developers?

592






How to find 3rd highest salary of an employee from the employee table in sql?

562


what is sql? : Sql dba

555


What is the difference between drop and truncate commands?

484


Are null values same as that of zero or a blank space?

526


what is myisam? : Sql dba

572


how to concatenate two character strings? : Sql dba

546


What is the difference among union, minus and intersect?

544


How do I save a sql query?

542


How many scalar data types are supported in pl/sql?

518


What is a join query?

546