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
- 8942 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gyana ranjan behera
simply write the sql query like
sql>select Emp_ID from table_name groupe by Address_ID
having count(Address_ID )>1;
this is working as per the requirement..i tested
that..thanx ..pls send responces and questions on my mail
id to discuss new situations.
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / shashi
select Emp_ID from table_name groupe by Emp_ID
having count(Address_ID )>1;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / nithya
select Emp_ID from table_name group by Address_ID
having count(Address_ID )>1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vijayakumar
we need some sample data's ... then only we can able to write exact query....becoz here emp_id and address_id both are unique.. same data will not repeated....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / abc
select emp_id from table_name a where a.rowid < (select MAX
(rowid) from test b where b.address_id=a.address_id)
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
How do I connect to oracle?
How to use values from other tables in update statements using oracle?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
How can I create database in oracle?
create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......
What is Hash Cluster ?
how to genarate random numbers in oracle for particular row?
What is a Data Dictionary ?
What is oracle database client?
How can I combine multiple rows into a comma-delimited list in oracle?
How to select an oracle system id (sid)?
does Oracle has only one table space?
Oracle General 
