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
- 7 Answers
- 8941 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nitin
SELECT EMP_ID FROM EMP_ADDRESS WHERE ADDRESS_ID IN
(SELECT ADDRESS_ID FROM EMP_ADDRESS
GROUP BY ADDRESS_ID
HAVING COUNT(ADDRESS_ID) >1)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Can you tell me how to add new column in existing views?how?How is possible?
How much memory your 10g xe server is using?
How to check the oracle tns settings?
What are the different types of trigger and explain its various uses and functions?
if you ctreate table identity
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to view the data files in the current database?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to create an oracle testing table?
What are the ways tablespaces can be managed and how do they differ?
What is sequence?
How to connect to the server with user account: sys?
How to compare dates in oracle sql?
What do you mean by cdb and pdb in oracle 12c?
What is raw datatype in oracle?
