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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which types of join is used in sql widely? : Sql dba

618


What is view explain with example?

597


What is difference between function and trigger?

632


Can you have a foreign key without a primary key?

589


How do you modify a table in sql?

680






what is online transaction processing (oltp)? : Sql dba

625


what is clause? : Sql dba

674


What are two statement types in sql?

636


Is sql scripting language?

620


How do I count duplicates in sql?

637


What are all the ddl commands?

753


When can we use the where clause and the having clause?

664


what is 'mysqld'? : Sql dba

625


What is difference between inner join and self join?

683


What is a delimiter in sas?

640