<div>
see if this works for you<br />
<br />
select * from yourtable<br />
where id in (select id from yourtable group by id having count(distinct addr) &gt;&nbsp;1)<br />

</div>


see if this works for you

select * from yourtable
where id in (select id from yourtable group by id having count(distinct addr) > 1)


<div>
<div class="content wysiwyg-content">
i Have<br />
<br />
ID &nbsp; &nbsp;ADDR<br />
1001 &nbsp;'AAA'<br />
1001 &nbsp;'BBB'<br />
<br />
1002 &nbsp; 'BBB'<br />
1003 &nbsp; 'CCC'<br />
1002 &nbsp; 'BBB'<br />
<br />
how can i find how many same ID has different ADDR OUPUT<br />
<br />
ID &nbsp; &nbsp;ADDR<br />
1001 &nbsp;'AAA'<br />
1001 &nbsp;'BBB'
</div>
</div>


i Have

ID    ADDR
1001  'AAA'
1001  'BBB'

1002   'BBB'
1003   'CCC'
1002   'BBB'

how can i find how many same ID has different ADDR OUPUT

ID    ADDR
1001  'AAA'
1001  'BBB'

finding different address based on same id

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.