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

Write a sql select query that only returns each name only once from a table?

997

What are the different type of joins in sql?

938

How much does sql certification cost?

1068

Is sql better than access?

997

What are the operators used in select statements?

1045

What is the example of procedure?

912

What are the types of variable use in pl sql?

1060

How many sql core licenses do I need?

932

Enlist some predefined exceptions?

1041

Explain raise_application_error.

1079

What version is sql?

1010

Explain two easy sql optimizations.

997

How do I access sql anywhere database?

954

Is there any restriction on the use of union in embedded sql?

1149

Explain polymorphism in pl/sql.

1102