SELECT * FROM EMP WHERE ROWID = (SELECT MIN(ROWID) FROM EMP) UNION SELE

how to retrieve 1st and last row of table without using
group functions??

Question Posted / ajitnayak

Answer Posted / ajitnayak

SELECT *
FROM EMP
WHERE ROWID = (SELECT MIN(ROWID) FROM EMP)
UNION
SELECT *
FROM EMP
WHERE ROWID = (SELECT MAX(ROWID) FROM EMP)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an oracle data file?

1050

Can we write dml statement in function in oracle?

1040

How do I manually create a database in oracle?

973

How to sort the query output in oracle?

978

What is an oracle cursor variable?

1023

How to find out what oracle odbc drivers are installed?

987

Can I create users through internet explorer in oracle 10g?

1029

What are temporal data types in oracle?

1076

Is a rollback possible to any savepoint?

1016

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1887

Explain the use of grant option in imp command.

966

11. Display the client number and name and the client number and name of the person who referred that client.

2285

How to count duplicated values in a column in oracle?

997

What is difference between sid and service name in oracle?

914

Can we protect our pl/sql source code?

1001