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...

i have a table with the columns below as
Emp_ID Address_ID Address_Line City Country
-------- --------- ----------- ------ ---------

Q: Display the Emp_ID's those having more than one
Address_ID

Answer Posted / vijayakumar

we need some sample data's ... then only we can able to write exact query....becoz here emp_id and address_id both are unique.. same data will not repeated....

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you tell what your machine name is and what is its IP address?

2001


What are the oracle differences between nvl and coalesce

1064


What is the database name in oracle?

967


How to resolve the ORA-39133 error in Oracle?

1029


master table and child table performances and comparisons in Oracle ?

2065


How to delete a column in an existing table?

1015


What is oracle datasource?

919


What is bind variable in oracle 11g?

990


Explain the importance of .pll extension in oracle?

950


Can objects of the same schema reside in different tablespace?

999


How to start a new transaction in oracle?

1014


What is the difference between primary key and unique key and foreign key in oracle?

915


How to enter a new row into a table interactively?

958


How to assign query results to variables?

1007


How many types of tables are there in oracle?

1001