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

Which is the correct statement about truncate and delete?

1172

what is the difference between a local and a global temporary table? : Sql dba

1126

Does sql*plus also have a pl/sql engine?

1131

Is like operator in sql case sensitive?

1077

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

1146

What is a full join?

1043

What can you do with pl sql?

1141

What are functions in sql?

995

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1132

What is trigger and how to use it in sql?

1066

Is oracel sql developer written in java?

1167

How to get each name only once from an employee table?

1159

What is microsoft t sql?

985

Name three sql operations that perform a sort.

1062

What is a constraint?

1082