Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get last 10 records from the table.
- 12 Answers
- 26775 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / siddharthapenchala
select * from <TN>
minus
select * from <TN>
where
rownum <= (select count(*) - &n from <TN>)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is trigger point?
What are the ways on commenting in a pl/sql code?
what are the different tables present in mysql? : Sql dba
Is pl sql still used?
What is full form of rtm?
what is union, minus and interact commands? : Sql dba
how is exception handling handled in mysql? : Sql dba
what is a relationship and what are they? : Sql dba
how many ways we can we find the current date using mysql? : Sql dba
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is materialized view in sql?
Can a commit statement be executed as part of a trigger?
What is a composite primary key?
What are the parameter modes supported by pl/sql?
