python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - exists

How to remove records with blank values based on existence in specific column? - SQL

I want to remove all records with blank values in prev and next - but only for cases where the curr value still exists elsewhere. For example, Input: prev curr next rand_value B ...
test-img

Ricardo Francois

sql

amazon-redshift

exists

sql-null

Votes: 0

Answers: 2

Latest Answer

You can use NOT EXISTS: SELECT t1.* FROM tablename t1 WHERE t1.prev IS NOT NULL OR t1.next IS NOT NULL OR NOT EXISTS ( SELECT 1 FROM tablename t2 WHERE t2.curr = t1.cur...
test-img

forpas

Postgres - select rows except where count is more than one and another condition

I have a table with the following sample data: appuser_id business_id role_id 6 2 CLIENT_MANAGER 8 2 CLIENT_ADMIN 6 3 ...
test-img

Mankind1023

sql

postgresql

where-clause

exists

Votes: 0

Answers: 1

Latest Answer

As it was suggested in the comment, you can use not exists: select * from my_table mt where mt.appuser_id = 6 and mt.role_id = 'BUSINESS_MANAGER' and mt.business_id not in ( select imt.business_id...
test-img

Andronicus

Changing In to Exists in SQL - with DISTINCT

Having this one: code IN ( SELECT DISTINCT aaa.code FROM ORGHEADER AS aaa LEFT JOIN ORGRELATEDPARTY AS bbb ON aaa.oh_pk = bbb.parent WHERE aaa.oh_pk NOT IN ( SELECT fu.parent FROM ORGRELATEDP...
test-img

Vityata

sql

teradata

exists

sql-in

teradatasql

Votes: 0

Answers: 1

Latest Answer

You have already redundant code. Inside the IN subquery you are selecting a column from ORGHEADER, so the LEFT join only adds noise since it returns in any case all rows from ORGHEADER. Assuming that ...
test-img

forpas

MySQL Select where in array of statuses and last occurrence equals specific value

Let's say I have a table like this: id user_id status updateded_id 1 1 yes 2/5/2013 2 2 no 2/1/2013 3 3 yes 1/28/2013 4 2 yes 1/24/2013 5 2 n...
test-img

matisa

mysql

laravel

inner-join

exists

groupwise-maximum

Votes: 0

Answers: 3

Latest Answer

You could do this. A user has multiple statuses and you want to get the users based on the latest status right? Eloquent user model class User extends Authenticatable { use HasApiTokens, HasFactor...
test-img

sithuaung

Posts

Questions

Blogs

Jobs