select* from employees where rowid=(select min(rowid) from employees) uni

How to retrieve first and last records from a table?

Question Posted / avnish srivastava-test engg fc

Answer Posted / avnish srivastava-test engg fc

select* from employees where rowid=(select min(rowid) from
employees)
union
select* from employees where rowid=(select max(rowid) from
employees)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is oracle a programming language?

990

What do you mean by group by clause?

1045

Can we protect our pl/sql source code?

1046

What happens if you set the sga too low in oracle?

1153

How to add another datafile to a tablespace?

1040

How many categories of data types?

997

What to do if the startbd.bat failed to start the xe instance?

1083

material view and view disadvantages?

1074

What are the major difference between truncate and delete?

1058

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078

How to create a new table in oracle?

1158

What are oracle functions?

1031

What is control file used for?

1209

What is literal?

1007

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2355