SQL Tutorial


SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL LIKE
SQL ORDER BY
SQL Functions
SQL COUNT
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL JOIN
SQL OUTER JOIN
SQL Subquery
SQL UNION
SQL UNION ALL
SQL INTERSECT
SQL MINUS

SQL CREATE TABLE
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL INSERT INTO
SQL UPDATE
SQL DELETE FROM
Home
SQL Commands
Table Manipulation
SQL Syntax
SQL Logical Operators

SQL LOGICAL OPERATORS
  • = - Equal to

  • != or <> - Not equal to

  • > - Greater than

  • >= - Greater than or equal to

  • < - Less than

  • <= - Less than or equal to

  • in - Equal to any item in a list

  • not in  - Not equal to any item in a list

  • between - Between two values, greater than or equal to one and less than or equal to the other

  • not between - Not between two values

  • begins with - Begins with specified value

  • contains - Contains specified value

  • not contains - Does not contain specified value

  • is null - Is blank

  • is not null - Is not blank

  • like - Like a specified pattern. % means any series of characters. _ means any single character.

  • not like - Not like a specified pattern. % means any series of characters. _ means many single character.