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

Filtering a MySQL query with multiple conditions

I have my output array named "Feed Items" (fi): ( [0] => Array ( [reg] => 2015-08-03 13:39:00 [id] => fd7ec4107d16b07c1a13cbdd386af8d2cb05ffca [user_id] => de5fd44db1760b006b1909cf1db11a78b38e455c …
cwiggo
  • 2,541
  • 9
  • 44
  • 87
2
votes
1 answer

Wordpress get posts not in custom taxonomy term

The following code is supposed to get posts that do not have specific terms in a custom taxonomy. At the moment it still gets them. Is something missing. $args = array( 'numberposts' => '3', 'post__not_in' => $post_not_in, …
Walrus
  • 19,801
  • 35
  • 121
  • 199
2
votes
2 answers

Entity Framework query with "not in"

I have a simple (well easy, not simple) query of "not in" on related tables. SELECT CompetencyID, CompetencyName FROM Competency WHERE (Deleted = 0) AND (CompanyID = 1) AND (CompetencyID NOT IN(SELECT CompetencyID FROM CompetencyGroups WHERE…
ransems
  • 641
  • 7
  • 19
2
votes
1 answer

MySql Delete NOT IN - but compare entire rows

This should be relatively simple. I dug around the MySql docs and couldn't find relevant infos. The scenario is simple. I have a table with 3 columns. All are composite unique keys, in that, all keys together must be unique to be a valid row. How…
Joe
  • 427
  • 1
  • 6
  • 16
2
votes
4 answers

SQL NOT IN still includes rows that should be excluded

I have the following statement to find rows that include certain values but exclude others: SELECT * FROM tests WHERE author = 4 OR id = -999 OR id = 276 OR id = 343 OR id = 197 OR id = 170 OR id = 1058 OR id = 1328 OR id = 1417 AND…
Omair Vaiyani
  • 552
  • 7
  • 28
2
votes
2 answers

MySQL - NOT IN query in WHERE clause with same structure working on first table but not on second table

I want to adapt a simple MySQL query from one table to another table. The first query is working as intended but the second modified query is not displaying the expected result, but I can not figure out any difference in the structure. This question…
VolkaRacho
  • 191
  • 1
  • 2
  • 13
2
votes
3 answers

Need help optimizing MySQL query with "not in" join

My query is currently taking roughly 3 seconds, which I'm sure can be optimized. I just can't figure out how to optimize it. My app has a reasonably big products table (roughly 500,000 records). Each product can be listed on one of 50 domains…
rickdenhaan
  • 10,857
  • 28
  • 37
2
votes
2 answers

MYSQL NOT IN subselect Query

I'am trying to get the inverse of a selection from an sql query. Here is my scenario, I select the payments related to a family with a query, and those who have made a donation in the last 6 months are considered active. I am interested in the ones…
acalderon
  • 21
  • 2
2
votes
2 answers

linqpad - big NOT IN clause is going over the limit - any other way?- Linq to SQL

So i am taking the linqpad challenge: http://www.linqpad.net/Challenge.aspx and i've got a report to create of all prospects from one table not in another table, my linq is: //get customers from one table var salesNotCancelled =…
nathfy
  • 687
  • 1
  • 9
  • 11
1
vote
3 answers

Postgres - How to find id's that are not used in different multiple tables (inactive id's) - badly written query

I have table towns which is main table. This table contains so many rows and it became so 'dirty' (someone inserted 5 milions rows) that I would like to get rid of unused towns. There are 3 referent table that are using my town_id as reference to…
Roxy'Pro
  • 4,216
  • 9
  • 40
  • 102
1
vote
1 answer

How to use delete while using merge to update and insert query in oracle?

I am working with both PostgreSQL and oracle for same query. while updating using PostgreSQL, remaining entries gets delete and whichever matched get update. Same query using merge in oracle didn't delete non-updated entries. Postgres…
Sakshi
  • 31
  • 1
1
vote
2 answers

How to convert a NOT IN query into a JOIN query

I have this following query that needs to be optimized Select 1 As status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, e.name, e.short_description, e.image, …
Vishal Rathod
  • 13
  • 4
1
vote
1 answer

Not in condition using gorm in golang - dynamic not in condition for select statement

I have two databases Booking and Room. Booking has roomid as one of its field. I wrote a select statement which saves the rows retrieved in result variable as stated below. var result models.Booking rows, err :=…
Sheela Ippili
  • 13
  • 4
1
vote
2 answers

MySQL not returning values from NOT IN function

I currently am trying to write a query that shows customers with at least 5 orders and customer with no orders. Orders are tracked in their own table and in order to find customers with 0 orders we have to find the customers NOT IN orders. Below is…
abrush
  • 39
  • 1
  • 6
1
vote
1 answer

I hit a weird issue running a query against a PostgreSQL Database using NOT IN and don't understand why it didn't work

I have a hierarchical table with an id and parent_id column, the parent_id has a foreign key to the id column. Each row can only have one parent, but multiple rows can be tied to the same parent. I wanted to retrieve all the rows that didn't have…
Will Harrison
  • 565
  • 3
  • 8
  • 21
1 2 3
…
20 21