ASKER
I have an employee_ref_id column and can have multiple entry in address table.
When employee do any chnage a new row insert in address table and new row in employee table.
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
It sounds like a simple count in the address table:
select employee_id,count(*) from address_table group by employee_id;
Since you asked the question, I'm guessing it isn't that simple.
Can you please provide sample data from both tables and the expected results?