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
6218 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 does stand for in sql?

972

Is time a data type in sql?

909

How many types of normalization are there?

966

What is procedure and function in sql?

1001

What is oracle and pl sql?

1118

Is vs as in pl sql?

986

What are the different types of functions in sql?

1055

How can I delete duplicate rows?

1017

What is the primary use of normalization?

1004

Can we use pl sql in mysql?

1013

How many disk partitions should I have?

988

How can check sql version from command line?

1087

How do I debug a stored procedure?

1113

What is denormalization in a database?

1053

What is primary key and unique key?

1121