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
- 8734 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 tables are there in oracle?
What is a data lock in oracle?
What is backup in Oracle?
What is a trigger oracle?
Explain the use of indexes option in imp command.
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is system global area (sga) in oracle?
what is meant by magic query
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?
What are the different oracle database objects?
Calculate difference between 2 date / times in oracle sql?
What are the differences between lov and list item?
What are the limitations oracle database 10g xe?
What is blob datatype?
How to write numeric literals in oracle?
