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 many types of table in Oracle?

1124

What is an Oracle Instance?

1123

How to get a create statement for an existing table?

969

What is bulk collect in oracle?

997

What is meant by a deadlock situation?

1110

How to convert characters to numbers in oracle?

1065

How to assign a tablespace to a users in oracle?

1048

What are privileges and grants?

1067

Can you drop an index associated with a unique or primary key constraint?

1019

What is an oracle function?

1166

How would you go about verifying the network name that the local_listener is currently using?

2049

What is control file used for?

1209

What is an index associated with a constraint?

1040

Can a formula column be obtained through a select statement ?

2327

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

1078