select * from employees where employee_id=100 union select* from employe

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

Thanks in advance

Question Posted / gourav

13 Answers
18944 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / gourav

select * from employees
where employee_id=100
union
select* from employees
where employee_id=206;

Example

first coulumn_ id(100)
last column _id(206)

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is user defined functions? : Sql dba

977

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2529

Can we use ddl statements in stored procedure?

1097

How to select 10 records from a table?

1099

What is aggregate function in sql?

988

Is json a nosql?

917

Who is the owner of mysql database?

1002

How do sql databases work?

947

What is the execution plan in sql?

975

Is hadoop a nosql?

950

What is the need of a partition key?

942

How do I enable sql encryption?

969

Where do we use pl sql?

945

What is procedure and function in sql?

930

What is varchar used for?

1025