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
- 4824 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
How to test for null values?
How do you go back in sql?
Can a varchar be a primary key?
how many ways we can we find the current date using mysql? : Sql dba
Can function return multiple values in sql?
Which table is left in left join?
How many types of sql are there?
What are the string functions in sql?
What language is oracle sql developer?
discuss about myisam key cache. : Sql dba
what is bdb (berkeleydb)? : Sql dba
Explain what is an index?
What can I use instead of union in sql?
How do you select unique values in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
