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
6032 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 trigger in pl sql?

959

What is the purpose of a secondary key?

902

What are the two types of cursors in pl sql?

1004

Explain clause in sql?

962

How long it takes to learn pl sql?

952

How to know the last executed procedure?

1036

describe mysql connection using mysql binary. : Sql dba

995

What can I use instead of union in sql?

905

What is row_number () in sql?

935

What is sql stand for?

947

What is the difference between a primary key and a unique key?

1001

Can we rollback delete command?

936

How do I enable sql encryption?

969

what is cross join? : Sql dba

941

What is pivot table in sql?

1020