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
- 8536 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
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Can we convert a date to char in oracle and if so, what would be the syntax?
Explain the difference between a procedure and a function?
What are the different editions of oracle?
How to start instance with a minimal initialization parameter file?
How to create a server parameter file?
What is a nested table and how is it different from a normal table?
How to test null values?
How to fetch the row which has the max value for a column?
How do we get field details of a table?
How to assign a tablespace to a users in oracle?
What is data block in Oracle?
Explain oracle’s server parameter file.
How to define an anonymous procedure with variables?
What are the various constraints used in oracle?
