Thread
:
Select Non distinct in MySQL
View Single Post
Dec 3rd, 2007, 11:33 AM
#
4
Ancient Dragon
PFO God In Training
Join Date: Jun 2005
Location: near St Louis, MO. (USA)
Posts: 546
Rep Power:
4
Re: Select Non distinct in MySQL
Don't know about MySql but Sybase database the having clause can be somewhat slow, so I would code with the where clause
SELECT primarymac, COUNT(*) as count
FROM aidahardware
where count > 1
Ancient Dragon
View Public Profile
Find More Posts by Ancient Dragon