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

Which sql statement is used to return only different values?

1056

What is cursor and its types?

1152

How do I make my sql query run faster?

1017

How to return an array from java to pl/sql?

1181

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1132

Is it possible to create the following trigger: before or after update trigger for each row?

1353

What are transaction and its controls?

1089

What are string functions in sql?

1305

What is denormalization in a database?

1107

what is normalization? : Sql dba

1137

Why is a primary key important?

1104

What does the sign mean in sql?

1049

How to run sql statements with oracle sql developer?

1123

What is the starting oracle error number? What is meant by forward declaration in functions?

1042

What is the use of index in hive?

1054