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

What are the constraints available in sql?

1000

Why should I use postgresql?

973

Can a foreign key have a different name?

893

What is procedure explain with program?

952

What is a mutating table and a constraining table?

1038

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1023

Which is better trigger or stored procedure?

883

What is pl sql block structure?

975

What is pl sql code?

995

What is a dynamic query?

975

how many triggers are allowed in mysql table? : Sql dba

997

What are different joins used in sql?

1010

How does sql profiler work?

968

What is difference between left and right outer join?

934

Does sqlite need a server?

996