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

How to display the current date in sql?

1052

discuss about myisam index statistics collection. : Sql dba

937

What is difference between cursor and trigger?

1055

Can a foreign key be a duplicate?

895

What is package in pl sql with an examples?

1018

Is vs as in pl sql?

968

What is the usage of when clause in trigger?

1031

explain the difference between myisam static and myisam dynamic. : Sql dba

925

What is full form of rtm?

989

What is difference between sql function and stored procedure?

989

What is the difference between distinct and unique in sql?

920

How do I turn a list into a table?

944

What is cte?

961

Is sql procedural language?

952

Is primary key an index?

984