Question

calculate count from 4 sources, joins and exclusions

score 44 · Answer 1 · 2024-02-21T11:36:57.637000

44

Views

calculate count from 4 sources, joins and exclusions

Published on 21 February 2024 at 11:36

score 68 · Answer 2 · 2023-12-28T04:54:05.320000

68

Views

NOT IN returns wrong results with where

Published on 28 December 2023 at 04:54

score 96 · Answer 3 · 2023-12-12T09:59:08.663000

96

Views

sql condition multiple condition when column a =! column b BUT with exception

Published on 12 December 2023 at 09:59

score 131 · Answer 4 · 2023-05-10T12:09:55.520000

131

Views

Can't combine 'NOT IN' with CTE in a 'WHERE' clause

Published on 10 May 2023 at 12:09

score 978 · Answer 5 · 2023-04-18T07:50:37.407000

978

Views

How to use pandas.read_sql with a SQLAlchemy query that has a not_in() wiht more than 2100 parameters. DB is Microsoft's SQLServer

Published on 18 April 2023 at 07:50

score 146 · Answer 6 · 2023-04-17T13:42:29.913000

146

Views

SQL Alchemy not_in() subquery hangs the applications, but works separately

Published on 17 April 2023 at 13:42

score 32 · Answer 7 · 2023-03-16T12:42:36.583000

32

Views

SQL - duplicates subquery

Published on 16 March 2023 at 12:42

score 42 · Answer 8 · 2023-03-10T03:27:16.897000

42

Views

Find number of customer did not purchase any of the product in cell A4:A8 before or equal to year 2015

Published on 10 March 2023 at 03:27

score 72 · Answer 9 · 2023-01-31T06:15:25.477000

72

Views

SQL query to find all the states where store is not open?

Published on 31 January 2023 at 06:15

score 74 · Answer 10 · 2023-01-23T17:06:33.590000

74

Views

How to add an exception into a SQL Select statement?

Published on 23 January 2023 at 17:06

score 44 · Answer 11 · 2023-01-06T21:02:25.127000

44

Views

read a csv file and validate whether input parameter is in the csv file then bypass the purge process otherwise initiate purge process using python

Published on 06 January 2023 at 21:02

score 31 · Answer 12 · 2022-12-12T22:53:17.893000

31

Views

Problem with skiping the if conditions in python

Published on 12 December 2022 at 22:53

score 35 · Answer 13 · 2022-11-23T13:14:06.030000

35

Views

NOT IN/ NOT EXISTS || I am trying to get the IDs missing in a specific date. The table now tracks date and ID if manifested only

Published on 23 November 2022 at 13:14

score 524 · Answer 14 · 2022-11-10T18:51:13.913000

524

Views

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

Published on 10 November 2022 at 18:51

score 420 · Answer 15 · 2022-11-02T05:45:39.380000

420

Views

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

Published on 02 November 2022 at 05:45

score 53 · Answer 16 · 2022-10-16T08:51:22.760000

53

Views

How to convert a NOT IN query into a JOIN query

Published on 16 October 2022 at 08:51

score 4.3k · Answer 17 · 2022-09-27T15:05:21.903000

4.3k

Views

Kusto equivalent of SQL NOT IN

Published on 27 September 2022 at 15:05

score 31 · Answer 18 · 2022-09-14T08:26:08.663000

31

Views

SQL: Deleting Duplicates using Not in and Group by

Published on 14 September 2022 at 08:26

score 31 · Answer 19 · 2022-06-23T06:34:28.523000

31

Views

Oracle - insert only rows with column value which doesn't exist in table

Published on 23 June 2022 at 06:34

score 490 · Answer 20 · 2022-05-27T10:26:26.923000

490

Views

SQL Query to Identify Missing Records (NOT IN subquery)

Published on 27 May 2022 at 10:26

List Question

calculate count from 4 sources, joins and exclusions

NOT IN returns wrong results with where

sql condition multiple condition when column a =! column b BUT with exception

Can't combine 'NOT IN' with CTE in a 'WHERE' clause

How to use pandas.read_sql with a SQLAlchemy query that has a not_in() wiht more than 2100 parameters. DB is Microsoft's SQLServer

SQL Alchemy not_in() subquery hangs the applications, but works separately

SQL - duplicates subquery

Find number of customer did not purchase any of the product in cell A4:A8 before or equal to year 2015

SQL query to find all the states where store is not open?

How to add an exception into a SQL Select statement?

read a csv file and validate whether input parameter is in the csv file then bypass the purge process otherwise initiate purge process using python

Problem with skiping the if conditions in python

NOT IN/ NOT EXISTS || I am trying to get the IDs missing in a specific date. The table now tracks date and ID if manifested only

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

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

How to convert a NOT IN query into a JOIN query

Kusto equivalent of SQL NOT IN

SQL: Deleting Duplicates using Not in and Group by

Oracle - insert only rows with column value which doesn't exist in table

SQL Query to Identify Missing Records (NOT IN subquery)

Trending Questions

Popular # Hahtags

Popular Questions