« How to connect a textbox to a database in php using ms access?
Could I have tatoos and still be able to join the army (UK)? »

SQL help please. Thanks.?

Hi, I have the query

select distinct programcode, dept from studentaffairsview where termcode = ‘200900′;

I want to only show results where the programcode appears more than once. Can this be done?
Thanks

This’ll do it.

Select Count(programcode) as Instances, programcode from studentaffairsview
Where termcode = ‘200900′
Group by programcode
Having Count(programcode) > 1

This entry was posted on Thursday, December 24th, 2009 at 11:46 am and is filed under select distinct. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “SQL help please. Thanks.?”

  1. This’ll do it.

    Select Count(programcode) as Instances, programcode from studentaffairsview
    Where termcode = ‘200900′
    Group by programcode
    Having Count(programcode) > 1
    References :

Leave a Reply