SQLize Online / PHPize Online  /  SQLtest Online

DROP SCHEMA IF EXISTS project CASCADE; CREATE SCHEMA project; DROP TABLE IF EXISTS project.Patient; CREATE TABLE project.Patient ( ID INTEGER , value INTEGER ); INSERT INTO project.patient(id, value) VALUES(100, 566); INSERT INTO project.patient(id, value) VALUES(101, 567); INSERT INTO project.patient(id, value) VALUES(null, 596); INSERT INTO project.patient(id, value) VALUES(104, null); select * from project.patient where id in (100, null); select * from project.patient where coalesce(id,99) in (100, 99); select * from project.patient where value between 100 and 567;