SELECT MIN(Obs) FROM <Table_name> UNION ALL SELECT MAX(Obs) from

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

4 Answers
6398 Views
I also Faced
E-Mail Answers

Answer Posted / ajit

SELECT MIN(Obs)
FROM <Table_name>
UNION ALL
SELECT MAX(Obs)
from <Table_name>;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to pronounce postgresql?

1098

What are the dml statements?

1196

What are conditional predicates?

1128

explain the advantages and disadvantages of stored procedure? : Sql dba

1067

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

1099

how can you see all indexes defined for a table? : Sql dba

1053

How do I install sql?

1045

Is sql a case sensitive language?

1010

What is composite data type in pl sql?

1170

Can you join views in sql?

996

What is AUTH_ID and AUTH_USER in pl/sql ?

2237

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1068

Show how functions and procedures are called in a pl/sql block.

1188

Can we rollback after truncate?

1072

What are the datatypes available in pl/sql ?

1155