SELECT * FROM Table WHERE Field IS NULL

  1. A) Make a round-table talk on the state of film-making in this country. Be ready to make suggestions about the possible improvements in film-making.
  2. Battlefield 1942
  3. Bloomfield: uncore.
  4. Debate the following. Keep it in mind that some of the statements are disputable.
  5. E. Supply the suitable form of past tenses.
  6. End Select
  7. End Select

, SQL, , - . NULL-. NULL , . NULL . NULL- , ( SQL) , . . - SQL .

[NOT] LIKE [] . '%' () - , '_' () - - .

SELECT * FROMEmployees WHEREName LIKE '%'

:

SELECT * FROMEmployees WHEREName LIKE'__%'

: ѳ

[NOT] IN [] :

SELECT * FROMEmployees WHEREPosition IN( '', '')

[NOT] BETWEEN [] :

SELECT * FROMEmployees WHERESalary BETWEEN200 AND500

, 200 .. 500 ..

ʳ AND, OR NOT:

SELECT *

FROMEmployees

WHEREPosition IN( '', '')

ANDSalary BETWEEN200 AND500

SELECT *

FROMEmployees

WHERE(Position = '' ORPosition =

'')

ANDSalary BETWEEN200 AND500

SELECT *

FROMEmployees

WHERE NOT(Position = '' ORPosition =

'')




WordPress | 3. CGI / Perl | CGI . | | 4. SQL | | | SQL | SQL | SQL |

© um.co.ua -