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
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
How does a covering index work?
How to raise user-defined exception with custom sqlerrm ?
How much does sqlite cost?
What are different types of tables in sql?
What is java sql drivermanager?
What program will open a mdb file?
Why use subqueries instead of joins?
What is the use of index in hive?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is on delete set null?
Is sql injection illegal?
what are all the common sql function? : Sql dba
What is the purpose of my sql?
Is pl sql a programming language?
what is 'mysqldump'? : Sql dba