select *from t_name where rownum=1 union (select *from t

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 / mahendar reddy

4 Answers
6156 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is primary key secondary key alternate key candidate key?

1014

How can I tell if sql is running?

1032

How is use pl and sql?

1048

How do I run a script in sql developer?

933

what are myisam tables? : Sql dba

1014

Which command is used to delete a package?

1148

What is difference between nchar and nvarchar?

1006

What is the sql*loader? : aql loader

1039

Is inner join same as self join?

1107

Why use stored procedures?

1059

How do I make sql search faster?

982

How does a covering index work?

942

What is difference between pl and sql?

1034

Is sql open source?

953

Why do we use joins in sql?

956