Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Thanks in advance

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

Is sql better than excel?

1162


How do you explain an index number?

1116


What does count (*) do in sql?

1020


What are character functions?

1094


Why is pl sql needed?

959


what are the type of locks ? : Sql dba

971


What is sql server and ase?

1034


what are the differences between require and include, include_once and require_once? : Sql dba

1033


What does subquery mean in sql?

1060


What are the different dcl commands in sql?

1185


what is sql server agent? : Sql dba

1114


How many types of primary keys are there?

1043


How do you remove duplicates without using distinct in sql?

987


what is the difference between inner and outer join? Explain with example. : Sql dba

1036


what are all the common sql function? : Sql dba

1063