SQL Subset Query

This blog post goes with the Subset Query post. This is the SQL example with a few tips.

 

  • Doesn’t this look exactly like WQL Post? Yes it is supposed to look exactly alike, it is intended to show the same query so that it is easy to follow from one example to another.
  • For the positive query don’t return the PC name because of the possibility of duplicate PC Names instead return ResourceID
  • I also like to keep my query clean of the junk. I think that they run faster.

 

Below is what the positive query would look like.

SELECT v_GS_ADD_REMOVE_PROGRAMS.ResourceIDFROM v_GS_ADD_REMOVE_PROGRAMS v_GS_ADD_REMOVE_PROGRAMSWHERE v_GS_ADD_REMOVE_PROGRAMS.DisplayName0=’Visio 12’

Now the negative query

Select             v_GS_COMPUTER_SYSTEM.Name0from             v_GS_COMPUTER_SYSTEMWhere             v_GS_COMPUTER_SYSTEM.ResourceID not in ( SELECT                         v_GS_ADD_REMOVE_PROGRAMS.ResourceID            FROM                         v_GS_ADD_REMOVE_PROGRAMS v_GS_ADD_REMOVE_PROGRAMS            WHERE                                   v_GS_ADD_REMOVE_PROGRAMS.DisplayName0=’Visio 12′)

Hopefully this gives you an insight on how to create and use subset queries.

Leave a Reply

Your email address will not be published. Required fields are marked *