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
0
votes
2 answers

MS Access WHERE NOT IN not working

I have two databases, one for holding book records and one for holding loan records. The SQL below only doesn't work properly. It gives me the results where books have been returned, but not books that haven't been part of a loan. SELECT…
Ceiling_Phantom
  • 3
  • 2
0
votes
1 answer

VB.Net Lambda Expression

Please can someone assist. I am wanting to filter a list of items based on another list. I have a list of Electronics Device Models. I have and add function which allows the user to add models to the list. Within the Add function I have a combo box…
Richard Gale
  • 1,816
  • 5
  • 28
  • 45
0
votes
1 answer

SQL SELECT * WHERE value NOT IN list and IN another list

I want to select a SKU that is not in ('DC01','5000'), but is in ('1003','1039','1012') where the SUM is greater than 3. I intend to get back zero records, as the SKU '000000001041106003' is in '1003' with StockOnHand greater than 3, but has a…
Colin Roe
  • 774
  • 1
  • 18
  • 35
0
votes
1 answer

Python - Trouble with Twython api

I've written a python script which uses Twython to interact with twitter. It downloads the followers list into a variable (followers), and the list of people I'm following into another variable (friends). It should then automatically follow…
Alex
  • 2,270
  • 3
  • 33
  • 65
0
votes
2 answers

Using NotIn & Regex in MongoDB with PHP

I have a table with some user email address like: johndoe@somemail.com test@test_mail.com test2@test_mail.com admin@company_mail.com janedoe@someothermail.com sales@company_mail.com mruser@validmail.com I want to get the…
emrec
  • 65
  • 1
  • 4
0
votes
2 answers

Who did not report yesteray? mysql not in list

I have a list of hospitals (FacilityID_UUID) that have to submit data every day (date = create_date). On a given day, I'd like to establish which did NOT report on the previous day. Started with this: SELECT `FacilityID_UUID` FROM `TEST` where…
Farah
  • 75
  • 1
  • 2
  • 6
0
votes
1 answer

How to select rows within a table that are not in other tables

I am having some bother in selecting books that are neither translated books, books series' nor book sections. The structure looks like this. (sorry, stackoverflow won't let me post an image with less than 10 reputation) It uses class inheritance…
TheCurlyProgrammer
  • 27
  • 8
0
votes
2 answers

SQL if there is no row, insert row

Preface: I have a query that pulls sales data and measures against their target. The issue is that only people who have sold an item appears on the chart for a given month. Eventually everyone gets a sale and gets on the chart. To alleviate this…
user3486773
  • 1,174
  • 3
  • 25
  • 50
0
votes
3 answers

How to make my both query to a single query using subquery while taking negation of second query?

My both SQL Queries are give below:- 1) SELECT Pk_class_id FROM tbl_student JOIN tbl_class on tbl_student.fk_class_id = tbl_class.pk_class_id JOIN tbl_staff on tbl_staff.Pk_staff_id = tbl_class.fk_staff_id WHERE tbl_student.updated_at <= now() -…
jasim
  • 459
  • 1
  • 6
  • 24
0
votes
3 answers

Query Performance Opttimization using NOT IN(Oracle Sql Developer)

I have been trying to optimize performance to the following query. I request all experts in this field to give me a hand and suggestions. I have app. 70k records and my requirement says to remove duplicates. I need to improve the performance of the…
Cmen535
  • 25
  • 1
  • 3
  • 15
0
votes
2 answers

How i can optimize this query in mysql?

I have a query like this - SELECT CONCAT(u.name, u.deviceAlias), u.name, u.deviceAlias, j.description, u.description AS vlanDescription FROM vlaninterfaces u, interfacedescriptioninfo j WHERE u.interfacedescriptioninfoid = j.id …
Aamir
  • 738
  • 2
  • 17
  • 41
0
votes
1 answer

Replace "minus" operator with "not in" or "not exists" - Oracle

I have a query that I want to replace. I don't want to use the "minus" operator. SELECT t1_col1, t1_col2 FROM t1 WHERE (t1_col1, t1_col3) IN (SELECT t2_col1, t2_col2 FROM t2 WHERE t2_col3 = '123456' MINUS (SELECT t3_col1, t3_col2 …
Tomarto
  • 2,755
  • 6
  • 27
  • 37
0
votes
4 answers

How to avoid duplicate insert of dynamic values in SQL server

I want to write a query to insert dynamic values if they or NOT present therein already. So far I have tried this. INSERT MTB_AML..tb_aml_codes (aml_code, aml_desc) SELECT 'NRA', 'Non-Resident Alien' UNION SELECT 'DOM', 'Resident…
Reeya Oberoi
  • 813
  • 5
  • 19
  • 42
0
votes
1 answer

MySQL - replace LEFT JOIN inplace of NOT IN

Whats the right MySQL query with two LEFT JOINs between three tables? SELECT COUNT(1) FROM TABLE1 WHERE T1_ID NOT IN ( SELECT T2.T2_ID FROM TABLE2 T2 LEFT JOIN TABLE3 T3 ON T2.T2_ID=T3.T3_ID WHERE T3.T3_ID IS NULL ) Something like SELECT…
Murali Mopuru
  • 6,086
  • 5
  • 33
  • 51
0
votes
1 answer

How to omit some results but not all from a query

Say I have a table with a field called foo. Foo is a character field. I want to return all records where foo is: Not in ('ad','ca','qw') Not like '9%' unless it is '96321' Here is what I have but I am tripping up on how to get '96321' SELECT …
donL
  • 1,290
  • 3
  • 13
  • 37
1 2 3
…
20 21