Question : I have a table containing a part time working pattern consisting of start and end dates together with […]
Tag: coalesce
Oracle database – get two rows (A,B) for every (COD) row
Question : I have a Oracle database and a variable that can have a value for A and a value […]
Ignore the joins without any result in SQL Server
Question : Situation I’m making a SQL server query to filter data from the projects table (tblProjecten). This table got […]
How to select TOP 1 value from each column where value is not null
Question : I am trying to select many columns from a table where there can be multiple rows with the […]
How to SELECT TOP(1) with COALESCE to pick the top NOT NULL row for each column?
Question : I have a hierarchy of settings that have a default for everyone, can be overridden by groups, or […]
COALESCE with cast
Question : I’m pulling data from a jsonb column in Postgres, and casting it to an integer to compare it […]
joining tables with full outer join and… COALESCE?
Question : I have a few tables in an Oracle database linked by id – fk_id, if I do: select […]
How can I group the null results in this FULL OUTER JOIN with non-null responses?
Question : I am looking at the overlap and non-overlap (unique values) of users-ids from two different select statements using […]
oracle database filter with full outer join and coalesce intersect
Question : in a Oracle Database if I “shoot” SELECT RAP.IDPL, C41.TIP_COD_DESEU AS CD41,C41.STOC_VAL AS CANT41, C42.TIP_COD_DESEU AS CD42,C42.STOC_VAL AS […]
Why does SELECTing sum() return null instead of 0 when there are no matching records?
Question : This is but one of countless little details that make me frustrated all the time, forces me to […]
- 1
- 2