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

Explain the uses of control file.

994

How do you update a sql procedure?

974

what are null values? : Sql dba

902

What is union, minus and interact commands?

1214

what is collation? : Sql dba

1079

Can we use distinct and group by together?

994

What is the basic structure of an sql?

1033

What is join view in sql?

898

What do you mean by stored procedures? How do we use it?

931

Is primary key clustered index?

900

Does truncate release storage space?

1015

When to use inner join and left join?

906

what is data integrity? : Sql dba

988

What are packages in pl sql and also explain its advantages?

961

What are the types of functions in sql?

968