SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE tass ( empID int, tb INT CHECK (tb BETWEEN 10 AND 99), gosb INT CHECK (gosb BETWEEN 1000 AND 9999), data DATE, status VARCHAR(20) CHECK (status IN ('closed', 'open')) ); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (1, '18', '4234', '2024-07-14', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (2, '52', '4234', '2024-06-01', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (3, '52', '4234', '2024-06-30', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (4, '52', '4234', '2024-04-05', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (5, '52', '4234', '2024-05-05', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (6, '52', '4234', '2024-05-10', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (7, '96', '4234', '2024-03-11', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (8, '62', '4321', '2024-03-25', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (9, '32', '4214', '2024-02-15', 'closed'); INSERT INTO tass(empId,tb,gosb,data,status) VALUES (10, '54', '4134', '2024-06-17', 'closed'); SELECT * FROM tass; -- fetch SELECT * FROM tass WHERE (tb, gosb) IN ( SELECT tb, gosb FROM tass GROUP BY tb, gosb HAVING COUNT(*) = 1 ) UNION SELECT * FROM tass WHERE data = ( SELECT MAX(data) FROM tass WHERE data <= CURRENT_DATE