SQL Tutorial

Date . Time . Timestamp. Interval -- sub-category must be the same, Year-month . Day-time. UNION Examples. SELECT * FROM sp. UNION. SELECT CAST(' ' AS VARCHAR(5)), pno, CAST(0 AS INT) FROM p. WHERE pno NOT IN (SELECT pno FROM sp) sno pno qty S1 P1 NULL S2 P1 200 S3 P1 1000 S3 P2 200 P3 0 SQL Modification Statements ................
................