<div>
aplogies done it with...<br />
<br />
set rowcount 10000<br />
<br />
select ref, count(ref) as cnt from order<br />
where ref != null<br />
and ref != ''<br />
group by ref<br />
having count(ref) &gt;&nbsp;1
</div>


aplogies done it with...

set rowcount 10000

select ref, count(ref) as cnt from order
where ref != null
and ref != ''
group by ref
having count(ref) > 1

<div>
<div class="content wysiwyg-content">
Hi all,<br />
i need help with some sql. &nbsp;I have a table with 200,000 rows of data. &nbsp;one of the columns ref contains non unique values. &nbsp;I'm only interested in these rows if the ref values are not unique. &nbsp;If this is the case i'd like to know how many times they are being used.<br />
<br />
i would expect my select statement to return just 2 values, namely ref and the number of times ref value was used in the table.<br />
<br />
any suggestions?<br />
<br />
regards Peewee
</div>
</div>


Hi all,
i need help with some sql.  I have a table with 200,000 rows of data.  one of the columns ref contains non unique values.  I'm only interested in these rows if the ref values are not unique.  If this is the case i'd like to know how many times they are being used.

i would expect my select statement to return just 2 values, namely ref and the number of times ref value was used in the table.

any suggestions?

regards Peewee

SQL having count greater than 1

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.