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
- 4859 Views
- I also Faced
- E-Mail Answers
Answer Posted / arjun
select * from tablename where rowid=1
union
( select * from tablename
intersect
select * from tablename where rowid = ( select max(rowid)
from tablename));
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Is sql free?
Explain table and field in sql?
Why join is faster than subquery?
what happens if null values are involved in expressions? : Sql dba
What are all the different normalization?
What are the qualities of 2nf?
Define a temp table?
What is the maximum size of sqlite database?
what are enums used for in mysql? : Sql dba
How many columns should be in an index?
Why do we use procedures in pl sql?
What are the types of triggers in sql?
How do I view output in sql developer?
Explain the the delete statements in sql?
Explain what is dbms?
