how to find the First and Last Observation from the table: Ex: OBS Name Sal

how to find the First and Last Observation from the table:
Ex: OBS Name Sal Ans like: OBS Name Sal
105 E 5000--> 105 E 5000
102 B 2000 104 D 4000
103 C 3000
101 A 1000-->
104 D 4000

Question Posted / xxx

4 Answers
4845 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OB..

Answer / shailesh jori

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

Is This Answer Correct ?

5 Yes

3 No

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OB..

Answer / ajit

SELECT MIN(Obs)
FROM <Table_name>
UNION ALL
SELECT MAX(Obs)
from <Table_name>;

Is This Answer Correct ?

1 Yes

0 No

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OB..

Answer / mahendar reddy

select *from t_name where rownum=1
union
(select *from t_name
intersect
select *from t_name where rowid=(select max(rowid)from t-name));

Is This Answer Correct ?

0 Yes

0 No

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OB..

Answer / arjun

select * from tablename where rowid=1
union
( select * from tablename
intersect
select * from tablename where rowid = ( select max(rowid)
from tablename));

Is This Answer Correct ?

0 Yes

6 No

Post New Answer