Programming Forums - View Single Post

Ancient Dragon · Dec 3rd, 2007, 11:33 AM

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

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