Which one of the following SQL select statements will display a list of all vendors that do not yet have names entered in the vendor table? Question 8 options: 1) select vend_code, vend_name from...



Which one of the following SQL select statements will display a list of all vendors that do not yet have names entered in the vendor table?



Question 8 options:






































1)


select vend_code, vend_name from vendor where vend_name IS NULL;




















2)


select vend_code, vend_name from vendor where vend_name IS NOT NULL;




















3)


select vend_code, vend_name from vendor where vend_name = NULL;




















4)


select vend_code, vend_name from vendor where vend_name = NOT NULL;







Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here