sql plus 2 json columns could be null

David Diamant answered on August 21, 2022 Popularity 1/10 Helpfulness 1/10

answer sql plus 2 json columns could be null

Comment

SELECT COALESCE(amount ->> 'price', '0')::float + COALESCE(amount ->> 'discount', '0')::float as total_price FROM bill;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: null sql

Link to this answer
Share Copy Link

Contributed on Aug 21 2022

David Diamant

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.