Stack Overflow
Stack Overflow

Questions tagged [notin]

The NOT IN predicate acts opposite to the "IN" predicate. It can be used to specify multiple values that should NOT be present in a WHERE clause. Note that NOT IN never is true!

NOT Logical Operator

If you want to find rows that do not satisfy a condition, you can use the logical operator NOT. NOT results in the reverse of a condition. That is, if a condition is satisfied, then the row is not returned.

NOT IN can be represented as conjunction of NOT equal comparison operators.

A NOT IN (B, C) <=> (NOT A=B) AND (NOT A=C) If one of A or B is NULL, then NOT IN is not True (Undefined)

MSSQL NOT

IN Predicate

The IN predicate is used when you want to compare a column with more than one value. It is similar to a number of equals comparisons OR-ed together.

MSSQL IN Clause

308 questions
-2
votes
1 answer

How to determine if record is a part of NOT IN versus doesn't exist?

Rephrasing the original post. How can I use the following query, or similar: select * from table where name="Jack" AND ID NOT IN (1,2,3,4,5) ; To determine the difference between: Jack record found, but its ID exists in (1,2,3,4,5), thus nothing…
rolinger
  • 2,787
  • 1
  • 31
  • 53
-2
votes
1 answer

How to not select rows that does not exists in other table

I want to not select rows where record does not exists in other table I expect to not select 3 rows where it does not exists on LOCATION table but exist in CYCLE_COUNT_REQUEST code below
Jedi Ablaza
  • 171
  • 15
-2
votes
2 answers

NOT IN with OR operator MYSQL

I want to select rows where in a row, sender is not equal to any of the list element and if it is not equal , then check if recipient is not equal to any of the list element .Using NOT IN () having OR operator like: SELECT * FROM messages WHERE…
MR_AMDEV
  • 1,712
  • 2
  • 21
  • 38
-2
votes
1 answer

how by not choosing child value, make all parent value disappear from the result set

My data looks like this: same PolicyNumber can have different ClassCode. So how to eliminate all rows that contain PolicyNumber PACA1000101-00 if at least one ClassCode choosen to be NOT IN So if I say WHERE ClassCode <> 01183 I want all those…
Serdia
  • 4,242
  • 22
  • 86
  • 159
-2
votes
3 answers

not in feature in sql, confused by manager and employee

EMPLOYEE (fmane, minit, lname, ssn, birthdate, address, sex, salary, superssn, dno); KEY: ssn DEPARTMENT (dname, dnumber, mgrssn, mgrstartdate); KEY: dnumber. PROJECT (pname, pnumber, plocation, dnum); KEY: pnumber. WORKS_ON (essn, pno, hours);…
Joe liang
  • 31
  • 4
-2
votes
3 answers

Many to many relation filter

I have the following tables: user (id, firstname, lastname) follow (id, follower_id, following_id) Now imagine we have users with id 1, 2, 3, 4, 5 And user_id = 1 already following user 2 and 3. Now I want to write a query that gives me the…
Hossein Jalali
  • 15
  • 2
-3
votes
1 answer

SQL 1064 - You have an error in your SQL syntax when deleting across multiple tables

I'm trying to delete specific rows in multiple log tables, for activity that is > 5 days old. but want to keep the log activity if the visitor_id is found in log_customer. the following returns over 42 K rows: SELECT * FROM `log_url` ,…
Lionel Andre
  • 3
  • 1
1 2 3
…
20
21