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
6219 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 does a covering index work?

961

How to raise user-defined exception with custom sqlerrm ?

1129

How much does sqlite cost?

1040

What are different types of tables in sql?

998

What is java sql drivermanager?

1099

What program will open a mdb file?

964

Why use subqueries instead of joins?

1081

What is the use of index in hive?

1007

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

1074

What is on delete set null?

1089

Is sql injection illegal?

1025

what are all the common sql function? : Sql dba

1058

What is the purpose of my sql?

951

Is pl sql a programming language?

994

what is 'mysqldump'? : Sql dba

1108