SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
DROP SCHEMA IF EXISTS project CASCADE; CREATE SCHEMA project; DROP TABLE IF EXISTS project.Patient; CREATE TABLE project.Patient ( ID INTEGER , value VARCHAR(30) ); 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; select * from project.patient where value like '%6%'; select count((id, value)) from project.patient
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear