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
6220 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

How to use transactions efficiently : transact sql

1058

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1090

Why we use pl sql?

962

Can I learn sql in a week?

1076

What is sqlca in powerbuilder?

1018

What is a temporal table?

931

How do you create a unique index?

1049

Which join is like inner join?

1028

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2016

What is the size of partition table?

1048

What is the difference between python and sql?

1005

Can one improve the performance of sql*loader? : aql loader

1049

what is an index? : Sql dba

997

Is natural join and inner join same?

929

Can we join same table in sql?

1023