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 on delete restrict?

1066

What is cursor status?

1231

How many commands are in sql?

1115

What is procedure function?

1119

What are the three forms of normalization?

1090

What are the possible values that can be stored in a boolean data field?

1040

How to look at the current sql*plus system settings?

1207

What is sqlservr exe?

1022

What does := mean in pl sql?

1084

What does fetching a cursor do?

1130

What is the difference between numeric and autonumber?

1035

Can we create table inside stored procedure?

1008

What is sql and how does it work?

1244

Why is %isopen always false for an implicit cursor?

1149

Which is better trigger or stored procedure?

1011