The rows in the result established using a NULL are the extra rows added by the ROLLUP clause. A NULL value in the column know-how indicates a bunch of rows for a certain worth of dept_id but without having a certain expertise worth.In the event you have two tables Together with the similar schema or if two tables have a subset of columns in preval