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 compilation error in pl sql?

1023

Explain aggregate functions are available there in sql?

1048

What is the difference between pl and sql?

1153

Can you skip header records while loading? : aql loader

1100

Can unique keys be null?

947

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

1175

What is query syntax?

1017

What is sql key?

1043

how to dump a table to a file with 'mysqldump'? : Sql dba

1096

What is interval partition?

1098

Why do we need sharding?

1046

Is clustered index a primary key?

985

Is like operator in sql case sensitive?

1077

What does inner join mean?

1258

what are the nonstandard string types? : Sql dba

1203