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

Answer Posted / nitin

NAME EMP_ID
A 100
B 102
C 103
D 105
E 200
F 201
G 202
H 203
I 204

SELECT * FROM (select * from emp order by emp_id desc)
WHERE rownum <= 5

Is This Answer Correct ?    13 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between in and exists clause?

563


Why do we need databases?

565


explain normalization concept? : Sql dba

583


What is the requirement of self-join?

539


how to include numeric values in sql statements? : Sql dba

555






how to include comments in sql statements? : Sql dba

541


Is sql a backend?

545


What trigger means?

561


what are the disadvantages of mysql? : Sql dba

568


What is a full join?

519


define sql delete statement ? : Sql dba

555


how to get a list of indexes of an existing table? : Sql dba

512


What is pragma in pl sql?

595


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

552


Is sql better than excel?

516