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
- 8448 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ajit
Try with this its working
SELECT name,addres FROM ADDR WHERE name IN
(SELECT name FROM ADDR
GROUP BY name
HAVING COUNT(ADDRES) >1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of auditing in Oracle?
How to execute a stored program unit?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to use "in" parameter properly?
What are the benefits of ordbms?
How can I create database in oracle?
How to create a single index for multiple columns?
How can windows applications connect to oracle servers?
What is the max number of columns in an oracle table?
Explain the use of inctype option in exp command.
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is the difference between hot backup and cold backup in oracle?
What is a lookup table in oracle?
How to create a new user account in oracle?
What are the predefined tablespaces in a database?
