select * from table_name where rowid=(select min(rowid) from table

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

Question Posted / shailesh jori

4 Answers
6025 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

Please Help Members By Posting Answers For Below Questions

Explain the working of foreign key?

974

What is the use of non clustered index?

925

How does stored procedure reduce network traffic?

965

what is try_catch block in procedure

1653

How to create your own reports in sql developer?

971

Explain sql data types?

1032

What is the difference between sum and count in sql?

936

what is union? : Sql dba

964

What is difference between joins and union?

1042

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1113

what is the functionality of the function htmlentities? : Sql dba

890

What is dba in sql? : SQL DBA

993

Which sorts rows in sql?

967

What is the function that is used to transfer a pl/sql table log to a database table?

949

Which join is like inner join?

973