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
6401 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

Is sql better than access?

1070

How does index help in query performance?

1089

What is the use of & in pl sql?

1098

What do you understand by pl/sql cursors?

1148

What is a primary key called that is made up of more than one field?

1393

Can triggers stop a dml statement from executing on a table?

1160

What is sap sql?

1030

What is sql stand for?

1033

What is an invalid partition table?

1067

Explain unique key in sql.

1063

Which query operators in sql is used for pattern matching?

1012

Differentiate between sga and pga.

1208

How you improve the performance of sql*loader? : aql loader

1065

What are records give examples?

1054

Explain the significance of the & and && operators in pl sql.

1049