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

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

Question Posted / nitin

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

Please Help Members By Posting Answers For Below Questions

how can we repair a mysql table? : Sql dba

990

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1200

What is crud sql?

993

Is there any restriction on the use of union in embedded sql?

1169

What is the use of prepared statement?

1038

What is posting?

1042

What is left join in postgresql?

1057

how to return query output in html format? : Sql dba

1081

What is a unique constraint?

1086

What trigger means?

999

What are sql objects?

1085

When is a declare statement required?

1153

How exception is different from error?

1028

What is an invalid partition table?

1035

What is varchar data type in sql?

1090