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 are mysql timestamps seen to a user? : Sql dba

1117

what is rollback? : Sql dba

1081

What are the types of subqueries?

1048

How do you change a value in sql?

1000

Define commit?

980

What is cursor explain with example?

965

How do I find duplicates in sql?

916

what are the advantages of using stored procedures? : Sql dba

1092

What is meant by <> in sql?

940

What is count * in sql?

981

what are all the common sql function? : Sql dba

1044

What is rtm in testing?

1093

how to create a new view in mysql? : Sql dba

924

what is bdb (berkeleydb)? : Sql dba

1010

How do you use collections in procedure to return the resultset?

2229