InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 23:32:06 GMT20http://www.sqlservercentral.com/Forums/Topic403243-8-1.aspx[quote][b]GilaMonster (12/31/2010)[/b][hr]Please note: 3 year old thread.[/quote]Heh... and a seriously wrong answer to boot!Fri, 31 Dec 2010 23:54:01 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic403243-8-1.aspxPlease note: 3 year old thread.Fri, 31 Dec 2010 08:03:55 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic403243-8-1.aspxselect * from table group by ...having count(*)>4Fri, 31 Dec 2010 07:32:46 GMTwww.robben_11http://www.sqlservercentral.com/Forums/Topic403243-8-1.aspxselect * From Table group by ....having count(?)>(select count(?) from Table1):w00t:Fri, 31 Dec 2010 07:31:16 GMTwww.robben_11http://www.sqlservercentral.com/Forums/Topic403243-8-1.aspxTo quote Homer Simpson, 'Doh!'Thanks, that's what I needed.Wed, 26 Sep 2007 16:05:04 GMTjej1216http://www.sqlservercentral.com/Forums/Topic403243-8-1.aspxyour having clause just needs move after the group by statement and needs to be before the order by statementWed, 26 Sep 2007 16:01:32 GMTAdam Angelinihttp://www.sqlservercentral.com/Forums/Topic403243-8-1.aspxI can do a select count from a table, no problem:select BUSINESS_UNIT, ASSET_ID, count(*)from FS.dbo.PS_AIDgroup by BUSINESS_UNIT, ASSET_ID order by BUSINESS_UNIT, ASSET_ID, count (*) What I cannot come up with is a way to qualify the select for rows whose count is less than 4.select BUSINESS_UNIT, ASSET_ID, count(*)from FS.dbo.PS_AID---- having count(*) < 4 --- this doesn't cut itgroup by BUSINESS_UNIT, ASSET_ID order by BUSINESS_UNIT, ASSET_ID, count (*) I cannot find direction in the Help files, so I am posting here.TIA,jej1216Wed, 26 Sep 2007 15:56:37 GMTjej1216