Tag: sql

Complex SQL join condition to Eliminate the NULL

CREATE TABLE EMP ( E_ID INT, E_NAME VARCHAR(20), GENDER VARCHAR(20), CONTACT INT, AGE INT ); INSERT INTO EMP VALUES (1001,…