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
- 5399 Views
- I also Faced
- E-Mail Answers
Answer Posted / shailesh jori
select * from table_name where rowid=(select min(rowid) from table_name) or rowid=(select max(rowid) from table_name)
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is the difference between count 1 and count (*) in a sql query?
What is character functions?
what are the drivers in mysql? : Sql dba
What is the use of count (*) in sql?
What are the two types of exceptions.
Is sql a backend language?
What is trigger types of trigger?
What is left join in sql?
what tools available for managing mysql server? : Sql dba
define sql delete statement ? : Sql dba
what are the differences between char and nchar? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
What does sql stand for?
Can we call procedure in select statement?
What is server name sql?
