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 is a snapshot log?

1003


How to call a sub procedure?

1093


Explain what are the uses of rollback segment?

1004


What is the recommended interval at which to run statspack snapshots, and why?

2918


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2024


How to define default values for formal parameters?

1044


What is open database communication (odbc) in oracle?

1003


material view and view disadvantages?

1070


Can we write insert statement in function in oracle?

1087


How to bring a tablespace online?

1075


How to assign query results to variables?

1050


What is an oracle?

1010


How to call a stored function in oracle?

1018


Can you drop an index associated with a unique or primary key constraint?

1019


How data locks are respected in oracle?

1069