Write a query to get last 10 records from the table.
- 12 Answers
- 24688 Views
- iNautix, I also Faced
- E-Mail Answers
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
What are different types of sql commands?
What is your daily office routine?
What is the use of %rowtype?
Can two tables have same primary key?
How insert into statements in sql?
How do you identify a primary key?
What are the types of operators available in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the difference between the implicit and explicit cursors?
What is the difference between cluster and non-cluster index?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
what are all types of user defined functions? : Sql dba
What are predefined functions in sql?
Can a trigger call a stored procedure?
What are the disadvantages of file system?
