(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

Can you join views in sql?

955

What is sql in oracle?

1061

Explain table and field in sql?

1062

How are sql commands classified?

1089

Is pl sql useful?

994

Can we perform dml on view?

1044

how to shutdown mysql server? : Sql dba

1102

What are the different ways to optimize a sql query?

946

What are the features of pl sql?

1067

What is an emotional trigger?

1005

Explain the difference between drop and truncate commands in sql?

1053

Is it possible to update views?

959

describe transaction-safe table types in mysql : sql dba

1006

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

what is a table in a database ? : Sql dba

1040