Hi Everyone, How to get fist and last record from a table in oracle? Thanks

Hi Everyone,
How to get fist and last record from a table in oracle?

Thanks in advance

Question Posted / cmanojkumar

13 Answers
16101 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance..

Answer / cbigmudre

(select * from table limit 0,1)
union
(select * from table order by Id desc limit 0,1)

Is This Answer Correct ?

0 Yes

3 No

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance..

Answer / gourav

select * from employees
where employee_id=100
union
select* from employees
where employee_id=206;

Example

first coulumn_ id(100)
last column _id(206)

Is This Answer Correct ?

0 Yes

4 No

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance..

Answer / ravi singh

select * from table_name
where rownum = 1
union
select * from table_name
where rownum > (select (count(1) - 1) from table_name);

I think this should work. try

Is This Answer Correct ?

3 Yes

18 No

Post New Answer