(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

State few characteristics of pl/sql?

963

What is procedure explain with example?

937

What does the file extension accdb stand for?

956

How to display Row Number with Records in Oracle SQL Plus?

1025

How to run pl sql program in mysql?

997

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1050

what is normalization? : Sql dba

1068

What is an exception in PL/SQL? What are the two types of exceptions?

1275

What are the most important characteristics of pl/sql?

1134

How do temporal tables work?

937

What is the purpose of the sql select top clause?

1087

How can check sql version from command line?

1062

how to convert character strings to dates? : Sql dba

1040

how many groups of data types? : Sql dba

1000

What is rownum and rowid?

1018