SELECT * FROM EMP WHERE ROWNUM < 2 UNION SELECT * FROM (SELECT * FRO

Hi Everyone,
How to get fist and last record from a table in oracle?

Thanks in advance

Question Posted / ashwani kumar singh

Answer Posted / ashwani kumar singh

SELECT * FROM EMP WHERE ROWNUM < 2
UNION
SELECT * FROM (SELECT * FROM EMP ORDER BY EMPNO DESC )
WHERE ROWNUM < 2

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is normalization in sql?

994

what happens if you no create privilege in a database? : Sql dba

981

What is a dirty read sql?

1106

how to convert numeric values to character strings? : Sql dba

1082

how to write date and time literals? : Sql dba

945

Explain how exception handling is done in advance pl/sql?

985

What is left join in postgresql?

1028

How bulk collect improves performance?

984

Why do we need databases?

1021

Is a view faster than a stored procedure?

947

What is an inconsistent dependency?

1029

Enlist the characteristics of pl/sql?

1778

What are tables in sql?

1041

Differentiate between pl/sql and sql?

1129

explain access control lists. : Sql dba

977