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

How to drop an existing view in oracle?

946

How do I spool to a csv formatted file using sqlplus?

1034

Whats the benefit of dbms_stats over analyze?

2003

How to pass parameters to procedures?

1034

What are the database administrators utilities available?

1032

what is normalisation?what are its uses?

2273

Explain joins in oracle?

1037

What is an oracle user account?

993

Explain enable novalidate constraint.

1083

Explain what does a control file contain?

1099

How to define an oracle sub procedure?

1146

How to create a stored procedure in oracle?

1104

Explain the use of Merge statement in oracle 11g

1029

Point the difference between translate and replace?

1089

What is an oracle database table?

1015