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
how can we repair a mysql table? : Sql dba
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is crud sql?
Is there any restriction on the use of union in embedded sql?
What is the use of prepared statement?
What is posting?
What is left join in postgresql?
how to return query output in html format? : Sql dba
What is a unique constraint?
What trigger means?
What are sql objects?
When is a declare statement required?
How exception is different from error?
What is an invalid partition table?
What is varchar data type in sql?