Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
Answer Posted / ramesh
Select * from table_name where rowid =(select min(rowid)
from tanle_name)
union
select * from table_name where rowid = (select max(rowid0
from table_name);
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is varchar example?
How do you modify a table in sql?
What is group function in sql?
what is a control file ? : Sql dba
What is sql dialect?
What is function and procedure in pl sql?
what is isam? : Sql dba
Define overloaded procedure?
What are the various levels of constraints?
What is difference between stored function and application function?
What is before trigger?
What are the different types of constraints?
How many sectors are in a partition?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is secondary key?