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 set operators in sql?

1056

Which sql most popular?

975

What is sql integrity?

1135

How to revise and re-run the last sql command?

1146

What does seeding a database mean?

936

What is the limitation on the block size of pl/sql?

975

What are the two parts of design view?

1004

What is scalar function?

1033

What is self-join and what is the requirement of self-join?

1131

How can we optimize a sql query?

1031

Is left join inner or outer?

1003

Can a foreign key be a duplicate?

896

Does execute immediate commit?

1196

What is ttitle and btitle?

1049

What is over () in sql?

931