How to retrieve first and last records from a table?

Question Posted / naveen

Answers were Sorted based on User's Feedback

How to retrieve first and last records from a table?..

Answer / naveen

SELECT * FROM EMP WHERE ROWID IN(SELECT MIN(ROWID) FROM EMP)
UNION ALL
SELECT * FROM EMP WHERE ROWID IN(SELECT MAX(ROWID) FROM EMP);

Is This Answer Correct ?

22 Yes

0 No

How to retrieve first and last records from a table?..

Answer / 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

How to retrieve first and last records from a table?..

Answer / avnish srivastava-test engg fc

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

Is This Answer Correct ?

1 Yes

0 No

How to retrieve first and last records from a table?..

Answer / ganesh

hi Avnish Srivastava-test Engg Fc
plssssssss can u send the data base testing material
my mail id.... gan9000@gmail.com

Is This Answer Correct ?

0 Yes

0 No

How to retrieve first and last records from a table?..

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

How to retrieve first and last records from a table?..

Answer / reddy

select*from emp where rowid in (select min(rowid),max(rowid) from emp);

Is This Answer Correct ?

0 Yes

0 No

How to retrieve first and last records from a table?..

Answer / guest

select *from dual;

Is This Answer Correct ?

0 Yes

9 No