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
- 8728 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
How to write a left outer join with the where clause in oracle?
Explain the difference between a procedure and a function?
what happened to the global index when I truncate the data in one of the partition?
What is flashback in Oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the uses of Database Trigger ?
How to call a stored function in oracle?
What is a named program unit?
What is the difference between substr and instr?
What is an oracle database table?
What exactly do quotation marks around the table name do?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to create a server parameter file?
Use of an integrity constraint is better to validate data. Explain
