Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
Answer Posted / rajesh venati
this will also work
select * from table_name where rowid=(select min(rowid) from
table_name)
union
select * from table_name where rowid=(select max(rowid) from
table_name);
| Is This Answer Correct ? | 23 Yes | 2 No |
Post New Answer View All Answers
Is it possible to create the following trigger: before or after update trigger for each row?
How do I run pl sql in sql developer?
How do I remove sql developer from windows 10?
Is sql a oracle?
Can we insert delete data in view?
Explain what is a field in a database and record in a database?
Can we use insert statement in function?
Explain two easy sql optimizations.
what is isam? : Sql dba
How to take user input in pl sql?
Can we join tables without foreign key?
How do I install sql?
How to install oracle sql developer?
What is the use of prepared statement?
How do you delete a table?