SQL Server Course for Beginners with 100+ examples - NOT Operator

This video tutorial explains the use of the NOT operator in SQL Server. It begins with an introduction to the NOT operator, followed by an overview of the Amid DB database and the employee table. The tutorial then demonstrates how to display records from the table and how to implement the NOT operator to filter records where the salary is not 8000. The video concludes with a summary of the NOT operator's usage in SQL Server.

What is the primary function of the NOT operator in SQL Server?

• To display records that meet a certain condition

• To display records that do not meet a certain condition

• To update records in a database

• To delete records from a table

In the given example, which field is used to demonstrate the NOT operator?

• Employee ID

• Employee Name

• Employee City

• Employee Salary

What SQL command is used to display all records from a table?

• FETCH ALL FROM table_name

• DISPLAY * FROM table_name

• SHOW ALL FROM table_name

• SELECT * FROM table_name

Which employee's record is excluded when using the NOT operator with salary not equal to 8000?

• John

• Michael

• Emma

• Sophia

What should be removed from numeric values to avoid errors when using the NOT operator?

• Commas

• Single quotes

• Parentheses

• Double quotes