1 Reply Latest reply on Aug 7, 2017 11:36 AM by njoylif

    how to include multiple values in WHERE clause


      i am looking for the syntax to be able to include multiple values in a where clause for example.


      SELECT InterfaceID

      FROM Orion.NPM.Interfaces

      WHERE InterfacesID != '4016',  '3011'


      this will throw and error of course the desired result can be achieved using:

      Where InterfaceID != '4016' AND InterfaceID != '3011'


      however this will be far from optimal if scaled out to a large number to exclude.


      many thanks