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

How do you update a value in sql?

630

How do you optimize a stored procedure in sql?

582

how to delete an existing column in a table? : Sql dba

644

What is cold data?

584

can sql servers linked to other servers like oracle? : Sql dba

643

Can you have more than one trigger on a table?

614

How to execute a stored procedure?

660

what are date and time intervals? : Sql dba

645

Can we use joins in subquery?

659

Is ms sql is free?

624

Is sql harder than python?

729

What is rollback?

675

How do I order columns in sql?

619

What are the disadvantages of file system?

721

What is varray in pl sql?

659