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
What are the differences between in and exists clause?
Why do we need databases?
explain normalization concept? : Sql dba
What is the requirement of self-join?
how to include numeric values in sql statements? : Sql dba
how to include comments in sql statements? : Sql dba
Is sql a backend?
What trigger means?
what are the disadvantages of mysql? : Sql dba
What is a full join?
define sql delete statement ? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
What is pragma in pl sql?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Is sql better than excel?