Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to check if a row is null in sql

--Checks both null and empty

SELECT * 
  FROM T
 WHERE NULLIF(some_col, ' ') IS NULL;
Comment

PREVIOUS NEXT
Code Example
Sql :: foreign key mysql 
Sql :: mysql limit rows 
Sql :: how to get nears location in mysql with latitude and longitude 
Sql :: sql date get month 
Sql :: amazon linux postgresql client 
Sql :: mysqli last row 
Sql :: Alter table add column in SQL Server- NAYCode.com 
Sql :: create user sql server 
Sql :: sql distinct with count 
Sql :: ignore case like sql 
Sql :: SQL Server rename foreign key constraint 
Sql :: postgres delete all tables 
Sql :: mysql show table fields 
Sql :: how to delete user in mysql 
Sql :: sql server list locks 
Sql :: select sequence oracle 
Sql :: insert current date sql 
Sql :: postgresql set auto increment value 
Sql :: mysql command not working in linux 
Sql :: sql server backup table 
Sql :: database dump mysql command 
Sql :: oracle log files 
Sql :: sql current date 
Sql :: difference between super key and candidate key 
Sql :: postgres create column with default value 
Sql :: how to put value in variable mysql 
Sql :: oracle sql drop column if exists 
Sql :: how to query date in sql server 
Sql :: brew start postgres 
Sql :: install postgresql 10 centos 7 
ADD CONTENT
Topic
Content
Source link
Name
6+8 =