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 primary key sql?

713

What is an exception in pl/sql?

729

What are the different ddl commands in sql?

742

What are sql functions? Describe in brief different types of sql functions?

726

Mention what does plv msg allows you to do?

858

Is sql difficult?

924

Differentiate between syntax and runtime errors.

849

What is primary key and foreign key?

719

Can we use pl sql in sql server?

739

How to convert comma separated string to array in pl/sql?

813

what are the different type of sql's statements ? : Sql dba

701

How do you modify a trigger?

695

What are the query optimization techniques?

711

Is postgresql a nosql database?

791

What are the parts of a sql statement?

767