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
- 6215 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 the difference between the implicit and explicit cursors?
What is the command used to fetch first 5 characters of the string?
How do you go back in sql?
what is the bond code in materialized view?
how to include character strings in sql statements? : Sql dba
What is a primary key called that is made up of more than one field?
What is dml and ddl?
What is the best free sql database?
How to move files from one directory to another in pl sql?
What are the two different parts of the pl/sql packages?
What are conditional predicates?
when MSQL8.0 is in market
How do I edit a stored procedure?
What is left join example?
i have some prob lem to tell me about my self in interview first round ...
