(select * from table limit 0,1) union (select * from table order by Id de

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

Thanks in advance

Question Posted / cbigmudre

Answer Posted / cbigmudre

(select * from table limit 0,1)
union
(select * from table order by Id desc limit 0,1)

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is query optimization in sql?

990

What are the different set operators available in sql?

1032

What is where clause in sql?

1050

What does count (*) do in sql?

1020

Explain what is sql*plus?

1152

Is like operator in sql case sensitive?

1033

What is foreign key in sql with example?

944

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

1118

How do you delete duplicates in sql query using rowid?

954

What is not equal in sql?

1136

What is java sql connection?

1068

What is parallel hint?

1334

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1146

What are the types of functions in sql?

1027

What is the difference between distinct and unique in sql?

957