SELECT * from empl WHERE ROWID IN ( SELE

How to retrieve first and last records from a table?

Question Posted / abc

Answer Posted / abc

SELECT * from empl WHERE ROWID IN (
SELECT MAX(ROWID) FROM empl
UNION
SELECT MIN(ROWID) FROM empl
);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a new oracle data file?

560

What are the different editions of oracle?

591

What is proxy method?

545

Is oracle a programming language?

568

query optmization techniques and quwry analyser+projects+ppts

1932

what are the advantages of running a database in archive log mode?

1735

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1656

Explain user account with reference to oracle.

538

What are the various types of snapshots ?

562

What are the set operators union, union all, minus & intersect meant to do?

564

How to delete multiple rows from a table in oracle?

563

Explain rename?

554

What is the quickest way to fetch the data from a table?

568

What is the difference between alert log file and tarce file ?

1634

What is flashback in Oracle?

581