insert into employee(emp_no,emp_fname,emp_lname,dept_no) values(29346,null,'james','d2')
10102 ann jones d3
18316 john barrimore d1
25348 matthew smith d3
29346 james james d2
29347 NULL james d2
insert into employee(emp_no,emp_lname,dept_no) values(29346,'james','d2')
10102 ann jones d3
18316 john barrimore d1
25348 matthew smith d3
29346 james james d2
29347 NULL james d2
so no difference both are same