Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.


  • Presentation
  • Question
  • Answer

Question
By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'.
Answer
SELECT employee_id, last_name, first_name
FROM employees
WHERE last_name NOT LIKE 'A%';

By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'.


Question
By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'.
Answer
?

Question
By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'.
Answer
SELECT employee_id, last_name, first_name
FROM employees
WHERE last_name NOT LIKE 'A%';

By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'.

If you want to change selection, open document below and click on "Move attachment"

SQL Server: NOT Condition
employees table where the last_name does not contain a NULL value. Example - Combine With LIKE condition The SQL Server NOT condition can also be combined with the LIKE condition . For example: <span>SELECT employee_id, last_name, first_name FROM employees WHERE last_name NOT LIKE 'A%'; By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'. Example - Combine With BETWEEN condition The SQL Server NOT condition can also be combined with the BETWEEN condition . Here is an example of how you would combine the NOT Operator with

Summary

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.