SELECT ROWNUM, E1.* FROM ( SELECT * FROM Emp ORDER BY ROWNUM DESC )E1

Write a query to get last 10 records from the table.

Question Posted / swastik

Answer Posted / swastik

SELECT ROWNUM, E1.*
FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)E1
WHERE ROWNUM <= 10

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is lookup table in sql?

1002

Can unique keys be null?

871

Explain the uses of database trigger.

1078

What is the process of debugging?

1027

What is a join?

1035

Why we use cross join?

916

What is the purpose of a secondary key?

923

What are the types of index in sql?

1036

How do we accept inputs from user during runtime?

1023

What are dml commands?

978

What does bitemporal mean?

1027

What is trigger in flip flop?

977

What is where clause in sql?

1001

what is the command line end user interface - mysql? : Sql dba

943

What is %rowtype in pl sql?

947