with temp as (select * from emp order by rownum desc) select * from tem

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

Question Posted / pallavi v

Answer Posted / pallavi v

with temp as
(select * from emp order by rownum desc)
select * from temp where rownum < = 10

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the query optimization techniques?

888

What is a native sql query?

977

How delete all data from all tables in sql?

887

What are the different types of triggers?

1056

What does fetching a cursor do?

1022

What is percent sign in sql?

1214

Is truncate ddl or dml?

945

What is the basic structure of an sql?

1033

Can you select everything, but 1 or 2 fields, without writer's cramp?

933

What is sql analyzer?

962

What are tables and fields in the database?

1025

how to select unique records from a table? : Sql dba

1057

What are the benefits of pl/sql packages?

1034

what is msql? : Sql dba

943

How does sql*loader handles newline characters in a record? : aql loader

987