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

How many joins in sql?

1059

What is the difference between union and union all command?

1152

What are synonyms in sql?

1027

What is the difference between a database and a relational database?

1159

Does varchar need length?

1050

How does sql profiler work?

1065

What is the use of triggers?

1085

What is a behavioral trigger?

1026

What is the purpose of a sql?

1044

How do I save a stored procedure?

1070

Why do we use joins?

1101

How does left join work in sql?

1041

How do I count records in sql?

1054

Explain what is dbms?

1120

what are the disadvantages of mysql? : Sql dba

1210