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 java sql package?

1047

Is left join inner or outer by default?

987

How do I find duplicates in sql?

894

how can we repair a mysql table? : Sql dba

932

Is microsoft sql free?

1055

How does stored procedure reduce network traffic?

984

What is user in sql?

983

What are the different datatypes available in PL/SQL?

1045

Explain the purpose of %type and %rowtype data types?

889

Which join is default?

909

explain the advantages and disadvantages of stored procedure? : Sql dba

972

What is left join in postgresql?

1008

Which join is like an inner join?

987

Is coalesce faster than isnull?

920

What is difference between stored function and application function?

1135