http://snippets.dzone.com/posts Wed, 23 Jul 2008 20:56:54 GMT DZone Snippets: distinct code http://snippets.dzone.com/posts/show/3334 // description of your code here <br /> <br /><code> <br />select count (*) as total from bppersondisabledstandardsetups group by setuptype; <br />select distinct bppersondisabledstandardsetups.setuptype from bppersondisabledstandardsetups; <br />select max(objid) from sdfields; <br /></code> Fri, 19 Jan 2007 17:17:24 GMT http://snippets.dzone.com/posts/show/3334 goodkail (Nicolás)