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

What is sql partition?

1038

What is the use of double ampersand (&&) in sql queries? Give an example

1082

What is sql rowcount?

952

What is rollback?

1042

What are the types of operators available in sql?

1011

what is datawarehouse? : Sql dba

957

Are subqueries better than joins?

923

What is a parameter query?

1024

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1111

What is the difference between a database and a relational database?

1040

Explain the difference between sql and mysql.

1003

Do we need to rebuild index after truncate?

976

What is the difference between instead of trigger and after trigger?

951

Why we use pl sql?

909

What is trigger in sql? Explain

946