The rows in The end result set which has a NULL are definitely the extra rows added by the ROLLUP clause. A NULL worth within the column abilities implies a bunch of rows for a selected value of dept_id but with no a certain expertise worth.Look for Console is actually a free Software that any website owner can use to find where their website ranks