select PO_header_id from (select PO_header_id from PO_HEADERS

Write a query to get last 10 records from the table.

Question Posted / nzabin

Answer Posted / nzabin

select PO_header_id from (select PO_header_id from PO_HEADERS_ALL order by PO_header_id
desc) where rownum <=10 order by PO_header_id;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to convert comma separated string to array in pl/sql?

1185

what is oracle database ? : Sql dba

1030

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1003

What is the purpose of the partition table?

1049

Explain what is a database?

1087

Does sql*plus have a pl/sql engine?

1075

What does cursor do in sql?

1025

What are keys in sql?

1000

What is the purpose of a secondary key?

977

what are the authentication modes in sql server? : Sql dba

1065

What is cursor in pl sql?

1118

Is pl sql and postgresql same?

1135

what is a stored procedure? : Sql dba

1133

Is primary key an index?

991

Can 2 queries be executed simultaneously in a distributed database system?

1143