select rownum, p.* from (select * from <table name> order by param

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

Question Posted / sudhir

Answer Posted / sudhir

select rownum, p.*
from (select * from <table name> order by param_cd desc) p
where rownum <= 10 ;

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is view explain with example?

514

What is the difference between function and procedure in pl/sql?

531

what is datawarehouse? : Sql dba

563

How do I send sql query results to excel?

575

What is sqlservr exe?

474

What can I use instead of union in sql?

507

Which table is left in left join?

516

How do I create a sql script?

538

explain about mysql and its features. : Sql dba

543

Can we use having without group by in sql?

547

What will you get by the cursor attribute sql%notfound?

586

How to get unique records from a table?

517

What is a table partition?

589

what is row? : Sql dba

703

What is the difference between the conventional and direct path loads? : aql loader

687