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
- 5406 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
What is not equal in sql?
how to enter binary numbers in sql statements? : Sql dba
Is primary key an index?
What is trigger types in sql?
What is query optimization in sql?
How to write a query to show the details of a student from students table whose
What is rowid in sql?
What is a null value?
What is latest version of sql?
What is trigger explain with example?
how is exception handling handled in mysql? : Sql dba
What is a join query?
Is oracle and sql same?
How is a process of pl/sql compiled?
What is dml statement?
