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

Is oracle and sql same?

1078

How do I know if I have sql express or standard?

1067

What is procedure in pl sql?

1092

what happens if null values are involved in expressions? : Sql dba

1093

How can you load multi line records? : aql loader

1126

What are types of indexes in sql?

1136

What is schema in sql?

1002

What is a schema sql?

1228

What is rowtype?

1081

Explain ttitle and btitle.

1165

Are stored procedures compiled?

980

What is the location of pre_defined_functions.

1212

Is inner join faster than left join?

1251

How is data stored in sql?

1103

What is server name sql?

1207