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
- 4 Answers
- 4858 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
What is the difference between left and left outer join?
What are the different types of functions in sql?
What is the purpose of the sql select top clause?
What is a temp table?
How do I remove sql plus from windows 10?
What are sql commands?
Why do we need unique key in a table?
Explain the difference between 'between' & 'and' operators in sql
What is normalization in sql?
What is cascade in sql?
What is sql constant?
Can %notfound return null after a fetch?
What is sql in java?
What is the usage of sql functions?
Can delete statement be rollbacked?
