Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6153 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 are % type and % rowtype?
Can procedure in package be overloaded?
How exception is different from error?
What are the constraints available in sql?
Who is the owner of mysql database?
What is a primary key? Explain
What is difference between pl and sql?
Define select, insert, create, delete, update, drop keywords
What are the triggers associated with image items?
what is the difference between sql and t-sql? : Transact sql
Which is faster view or stored procedure?
What is view? Can we update view
how can we destroy the cookie? : Sql dba
Why we use triggers in mysql?
Is primary key clustered or nonclustered?
