Tag: null

using sql – Is not null in a select statement

I can’t seem to figure out how to use the opposite of isnull or ifnull statements in sql. I need to say if a.Error1 is not null — then print the ‘ – ‘ and the + CHAR(13)+CHAR(10). Basically There should be no dash or no new line break if the a.Error1 comes back null. So print the information if

Best way to check for “empty or null value”

coalesce database null postgresql sql

What is best way to check if value is null or empty string in Postgres sql statements? Value can be long expression so it is preferable that it is written only once in check. Currently I’m using: But it looks a bit ugly. stringexpression may be char(n) column or expression containing char(n) columns with trailing spaces. What is best way?

Avoid division by zero in PostgreSQL

aggregate-functions divide-by-zero null postgresql sql

I’d like to perform division in a SELECT clause. When I join some tables and use aggregate function I often have either null or zero values as the dividers. As for now I only come up with this method …

ILIKE and NOT ILIKE in aws redshift different from total

amazon-redshift count null sql

I ran three following queries in amazon redshift: The count was 1554. The count was 62. The count was 85. The last two (62 + 85) should equal 1554. What am I missing? Answer Double-quotes are for identifiers: “myColumn” Single quotes are for values: ‘value’. Your examples contradict those basic syntax rules. Also, you did not consider NULL values, which

Null or empty check for a string variable

null null-check sql sql-server-2008

I want to know whether the above piece of code works in checking if the variable is null or empty. Answer Yes, that code does exactly that. You can also use: Edit: With the added information that @value is an int value, you need instead: An int value can never contain the value ”.

How to do NULLS LAST in SQLite?

null sql sqlite

I’d like to sort my result with all NULL columns last (NULLS LAST), as specified in the SQL:2003 extension T611. Sadly, SQLite seems to not support it. Is there a clever workaround?

MySQL comparison with null value

isnull mysql null sql

I have a column called CODE in a MySQL table which can be NULL. Say I have some rows with CODE=’C’ which I want to ignore in my select result set. I can have either CODE=NULL or CODE!=’C’ in my result …

Concatenate with NULL values in SQL

concatenation database null sql string

Column1 Column2 ——- ——- apple juice water melon banana red berry I have a table which has two columns. Column1 has a group of words and Column2 …

Cannot insert the value NULL into column

null sql sql-update

I’m having some problems. I am trying to get a table to update, however it is not updating because one of the fields contains rows with a NULL value. Heres the original query which gives no error: Now, the nextUpdate column might be NULL, so I am trying to accommodate for that with this query: You can see I’ve added

Conditional NOT NULL case SQL

mysql mysql-error-1064 null sql

I am trying to calculate a field and I want it to behave differently depending on if one of the columns happens to be null. I am using MySQL Is this the right syntax? Answer You need to have when reply.replies IS NOT NULL NULL is a special case in SQL and cannot be compared with = or <> operators.