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

What are the major difference between truncate and delete?

1137


How to create additional tablespaces for an new database?

1079


What are the limitations of check constraint?

1076


List out the difference between commit, rollback, and savepoint?

1095


What is the difference between postgresql and oracle?

1108


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3101


How to assign a table row to a record variable?

1095


How do we get field details of a table?

1030


Can objects of the same schema reside in different tablespace?

1104


what is reindexing?

1732


Can we create trigger on materialized view in oracle?

1045


Why should I use oracle database?

1050


What is bind variable in oracle 11g?

1097


why dont we assign not null constraint as table level constraint.

2798


How to connect ms access to oracle servers?

1059