Top "Coalesce" questions

LINQ to SQL C# COALESCE

Given the following table: Length | Width | Color | ID =========================== 18 | 18 | blue | 1 --------------------------- 12 | 12 | red | 1 --------------------------- I want to produce a single column/row: …

sql linq coalesce

MySQL, IFNULL(), COALESCE() on String not replacing

My statement should replace every empty title_column with 'no name', but it doesn't: SELECT COALESCE(main_table.title_column, …

mysql sql replace coalesce ifnull

ERROR: COALESCE types bytea and character varying in PostgreSQL

I write a postgresql and pass parameter name1 from my java code with Spring + Hibernate. SELECT * FROM Test WHERE name = …

java hibernate postgresql coalesce

How to display a default value when no match found in a query?

I want to display a default message when there is no data obtained from a query. For example Let us …

sql oracle coalesce

ORDER BY with columns that are sometimes empty

My SQL looks something like this: SELECT CompanyName , LastName , FirstName FROM ... JOIN ... ORDER BY CompanyName , LastName , FirstName Now the problem …

sql sql-order-by coalesce

ANSI equivalent of IS NULL

I am trying to find the ANSI way to write the T-SQL 'IS NULL'. (corrected, was 'IN NULL') Some posts …

sql coalesce isnull ansi-sql

COALESCE with NULL

I found this snippet of SQL in a view and I am rather puzzled by it's purpose (actual SQL shortened …

sql sql-server tsql coalesce

SQL SERVER - Problems with COALESCE() function

I have this SQL function which is wrapped by a stored procedure: ALTER FUNCTION dbo.GetObjList ( @filterUID int = NULL, @filterSID …

sql-server coalesce sql-function

Postgresql COALESCE performance problem

I have this table in Postgresql: CREATE TABLE my_table ( id bigint NOT NULL, value bigint, CONSTRAINT my_table_pkey …

postgresql coalesce null-coalescing

SQL Return Null if One Column is Null (Opposite of COALESCE())

In advance, I would like to say thanks for the help. This is a great community and I've found many …

sql null coalesce