BuboFlash - helps with learning

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

This SQL Server NOT example would return all rows from the employees table where the first_name is not 'John', 'Dale', or 'Susan'. Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want.

Answer

SELECT *
FROM employees
WHERE first_name NOT IN ( 'John', 'Dale', 'Susan' );

Question

Answer

Question

Answer

SELECT *
FROM employees
WHERE first_name NOT IN ( 'John', 'Dale', 'Susan' );

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

SQL Server: NOT Condition
e condition be must be met for the record to be included in the result set. Example - Combine With IN condition The SQL Server NOT condition can be combined with the IN condition . For example: <span>SELECT * FROM employees WHERE first_name NOT IN ( 'John', 'Dale', 'Susan' ); This SQL Server NOT example would return all rows from the employees table where the first_name is not 'John', 'Dale', or 'Susan'. Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want. Example - Combine With IS NULL condition The SQL Server NOT condition can also be combined with the IS NULL condition . For example, SELECT * FROM employees WHERE last_name IS NOT NULL;

Summary

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised 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.