(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

how many values can the set function of mysql take? : Sql dba

932

How do you break a loop in pl sql?

984

What are the types of views in sql?

1037

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1000

What is the need of a partition key?

940

What are sql queries used for?

974

How do I make my sql query run faster?

889

How do I add a database to sql?

1058

What is cursor explain with example?

921

What are the limitations of sql express?

983

How does sql profiler work?

964

What is sql used for?

1059

how to get a list of all tables in a database? : Sql dba

915

What is procedure and function?

918

How to read/write files from pl/sql?

990