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 - sql-null

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

Passing NULL value into the SQL server with Android Studio

How do I accept null values into the SQL Server database with Kotlin? I am trying to make that if the user does not input anything into the column, it will return null instead in the SQL Server. But I...
test-img

Christopher Chua

sql-server

kotlin

sql-null

Votes: 0

Answers: 0

repeat value of a row when other row is null

I have a table like this: id | nu_cns | nu_cpf | co_dim_tempo | sifilis | hiv 908 | null | 347 | 1 | y | n 908 | 708 | null | 2 | y | y 908 | 708 | ...
test-img

Italo Rodrigo

sql

postgresql

aggregate-functions

missing-data

sql-null

Votes: 0

Answers: 2

Latest Answer

You can use last_value with frame clause rows between unbounded preceding and current row: select id, first_value(nu_cns) over (partition by id order by nu_cns rows between unbounded preceding and ...
test-img

Andronicus

SQL : duplicate columns with NULL values

I'm trying to get the number of quantities per month and per application taking into account a weighting: SELECT jan.app_name, fev.app_name, jan.api, fev.api, jan.user_id, fev.user_id, qt_janvier, qt_...
test-img

Alex

sql

postgresql

calculated-columns

sql-null

Votes: 0

Answers: 1

Latest Answer

You can use coalesce - this will take the first non-null value: select coalesce(jan.app_name, fev.app_name) app_name, coalesce(jan.api, fev.api) api, coalesce(jan.user_id, fev.user_id) user_id, qt_jan...
test-img

Andronicus

Posts

Questions

Blogs

Jobs