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
- 8741 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shashi
select Emp_ID from table_name groupe by Emp_ID
having count(Address_ID )>1;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to do paging with oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to store pictures on to the database?
What does sharding mean?
What are the different types of database objects?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What are the uses of Database Trigger ?
What is index-organized table in Oracle?
WHAT IS ecc 6.0
What happens to the indexes if a table is recovered?
Give the various rollback segment states.
How to Truncate Table in Oracle
What is the fastest query method to fetch data from the table?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is an oracle and why it is used?
