• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

sql query "select all but"

Hey Guys, I have a pretty simple question.
I need a query that will select all meters except 10 that I need to define.
Sounds easy but once again it's over my head.
any help would be great.
Sam
0
SamRunyon
Asked:
SamRunyon
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
WHERE your_field NOT IN ( 1,2,3,4,5,6,7,8,9, 10)
0
 
SamRunyonAuthor Commented:
Angellll,
Rank: Genius
for sure. :)

that will do it.
I am new enough to get in trouble.

again thanks, Sam
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now