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

What is the usage of when clause in trigger?

992

What is meaning of <> in sql?

1023

Can we use two order by clause in query?

919

How do you respond to dementia behavior?

926

Explain what is sql*plus?

1087

how to increment dates by 1 in mysql? : Sql dba

927

what is the difference between char and varchar data types? : Sql dba

1003

What is cursor explain with example?

924

What is the difference between in and between in sql?

996

explain commit and rollback in mysql : sql dba

942

Is pl sql a scripting language?

971

What is rank function in sql?

965

How to load data with sql*loader?

1000

What are the parts of a basic sql query?

920

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

1000