select * from employees where rowid = (select max(rowid)

How to retrieve first and last records from a table?

Question Posted / girija.112

Answer Posted / girija.112

select *
from employees
where rowid = (select max(rowid)
from employees)
or rowid =(select min(rowid)
from employees)

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what are the uses of rollback segment?

574

What is ceil and floor in oracle?

565

How to invoke the original export import utilities?

499

What is Library Cache in Oracle?

634

Difference between inner join vs where ?

601

What is oracle sid?

505

What are the different types of failures that occur in Oracle database?

590

Explain view?

571

What is oracle instant client?

556

What is system tablespace?

622

Explain an index?

654

Point the difference between translate and replace?

564

What is snapshot is too old? Give and example for better understand.

1089

What is oracle join syntax?

560

How to display row numbers with the records?

579