select * from tablename where rowid=1 union ( select * from tablename

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

4 Answers
6399 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between nvl function, ifnull function, and isnull function?

1156

What is rtm stands for?

1173

Is pl sql useful?

1037

What is trigger types of trigger?

1144

What is pl sql and why it is used for?

1158

Why we use sql profiler?

1023

what is view? : Sql dba

1029

What is an oracle stored procedure?

1117

Is sql microsoft?

1108

What is cte?

1025

What are the usages of sql?

1102

how to get a list of columns in an existing table? : Sql dba

1012

What is the difference between python and sql?

1056

What is recursive join in sql?

1070

Can we update views in sql?

989