How to retrieve first and last records from a table?
- 7 Answers
- 9359 Views
- DELL, QSmart, I also Faced
- E-Mail Answers
Answer Posted / reddy
select*from emp where rowid in (select min(rowid),max(rowid) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use like conditions in oracle?
What is a subquery?
what is Single Byte Overhead...?
What is a tns file?
What do you understand by a database object?
Is it possible to insert comments into sql statements return in the data model editor ?
What is tns entry?
What is the difference between hot backup and cold backup in oracle?
Calculate difference between 2 date / times in oracle sql?
How to create a table in a specific tablespace?
How do we get field detail of a table?
Describe varray?
What is oracle used for?
How to export your own schema?
What is the difference between view and materialized view in Oracle?
