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 an escape character in sql?

1009

Which sql most popular?

974

What does over partition by mean in sql?

958

Cite the differences between execution of triggers and stored procedures?

1072

What is dynamic query?

957

Can we use joins in subquery?

1143

What is tuple in sql?

1050

Can a table contain multiple foreign key’s?

983

What is your daily office routine?

2256

How much does a sql dba make? : SQL DBA

928

What has stored procedures in sql and how we can use it?

1054

What are pl sql data types?

996

Can we insert data in view?

948

what are string data types? : Sql dba

1025

Is sql a scripting language?

974