Question

Write a query to display details of employees with the text "Not given",if commission is null.

Answer 1

Answer:

select name , 'Not Given' from employees where commission = 'null';

Explanation:

please mark me as a brain list

Answer 2

A query to display details of employees with the text "Not given",if commission is null.

SELECT * FROM employees WHERE commission IS NULL AND job_title = 'Not given';

• SQL uses the IS NULL condition to check for a NULL value. If a NULL value is detected, it returns TRUE; otherwise, it returns FALSE. It is applicable to statements that SELECT, INSERT, UPDATE, or DELETE data.
• A database field that is null indicates that it has no value for the specified record. It implies that there is no worth. A database field that is empty (for a string value) or zero indicates that there is a value for the specified record (for a numeric value).
• In SQL, we occasionally need to enter rows containing NULL values into the tables due to a lack of data. The term NULL (without quotes) is used to denote a lack of data in this context. The following are some essentials of Null value: A zero value is distinct from a NULL value.

#SPJ2