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

Does pl sql work in mysql?

938

Why should I use postgresql?

985

How do you modify a column in sql?

961

How many joins can you have in sql?

897

Explain the working of foreign key?

1009

Explain what is sql?

1077

What are the different types of constraints?

1099

How can you select unique records from a table?

1015

what is the use of double ampersand (&&) in sql queries?

1134

What is auto increment feature in sql?

1082

what is the difference between a web-garden and a web-farm? : Sql dba

1031

What are sql built in functions?

903

how to use 'mysql' to run sql statements? : Sql dba

1005

What are the three pl sql block types?

961

How to run sql commands in sql*plus?

1116