• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 23 subscribers
  • Views 1327 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

how to include multiple values in WHERE clause

loftyyy

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

  • 0

    SELECT InterfaceID

    FROM Orion.NPM.Interfaces

    WHERE InterfaceID NOT IN (4016,3011)


    or perhaps more useful if dynamic need...

    SELECT InterfaceID

    FROM Orion.NPM.Interfaces

    WHERE InterfaceID NOT IN (

         SELECT InterfeaceID FROM Interfaces where <dynamic WHERE criteria here>

         )

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.