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 operators deal with null?

1111

What is view explain with example?

937

What is mdf ldf and ndf?

1005

What is meant by user defined function?

1055

Can we use joins in subquery?

1168

What is execute immediate?

1089

Why is normalization important?

1033

What is the use of sqlerrd 3?

945

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1113

How do I save a sql query?

1021

Can you rollback after commit?

995

How to install oracle sql developer?

1056

Is sql a case sensitive language?

951

how to analyze tables with 'mysqlcheck'? : Sql dba

1016

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

986