SELECT * from empl WHERE ROWID IN ( SELE

How to retrieve first and last records from a table?

Question Posted / abc

Answer Posted / abc

SELECT * from empl WHERE ROWID IN (
SELECT MAX(ROWID) FROM empl
UNION
SELECT MIN(ROWID) FROM empl
);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to see the table columns used in an index?

1024

What is index in Oracle?

1070

What is a named program unit?

1074

Can select statements be used on views in oracle?

1027

Which is better Oracle or MS SQL? Why?

4939

Is it possible to split the print reviewer into more than one region ?

2280

What is tns entry?

1149

Explain table?

1111

What are privileges and grants?

1065

What are the attributes of the cursor?

1002

Why does oracle 9i treat an empty string as null?

1054

How is it different from a normal table?

1030

How to create tables for odbc connection testing?

1115

How to use attributes of the implicit cursor in oracle?

1008

What types of joins are used in writing subqueries?

982