SQL Learning:

	Introduction
SQL Managing Databases
	SQL Database Content
	SQL Create Database
	SQL Listing Databases
	SQL Use Database
	SQL Alter Database
	SQL Drop Database
SQL Managing Tables
	SQL Tables Content
	SQL Create Table
	SQL Table Column Types
	SQL Table Primary Key
	SQL Auto Increment
	SQL Unique Columns
	SQL Table Constraints
	SQL Drop Table
	SQL Alter Table with ADD
	SQL Alter Table with MODIFY
	SQL Alter Table with DEFAULT
	SQL Alter Table with DROP
SQL Managing Indexes
	SQL Why Table Indexes
	SQL Create Table with Indexes
	SQL Create Index on Table
	SQL Alter Table Indexes
	SQL Drop Table Indexes
	SQL Rename Table Index
SQL Data Modification
	SQL Insert Table Data
	SQL Update Table Data
	SQL Delete Table Data
SQL SELECT
	SQL SELECT Overview
	SQL Column Selection & Design
	SQL Column Computation
	SQL FROM tables
SQL WHERE
	SQL WHERE Statement
	SQL Where Comparison
	SQL AND, OR, NOT
	SQL BETWEEN, NOT BETWEEN
	SQL IN, NOT IN
	SQL LIKE, NOT LIKE
	SQL NULL values & COALESCE
	SQL Operator Precedence
SQL Sorting and grouping
	SQL ORDER BY
	SQL DISTINCT
	SQL GROUP BY
	SQL HAVING
SQL Functions
	SQL Aggregate Functions
	SQL String Functions
	SQL Date and Time Functions
	SQL Numeric Functions
SQL JOIN Tables
	SQL JOIN Basics
	SQL JOIN with FROM/WHERE
	SQL INNER JOIN
	SQL CROSS JOIN
	SQL NATURAL JOIN
	SQL LEFT JOIN
	SQL RIGHT JOIN
	SQL FULL JOIN
	SQL JOIN with USING
	SQL JOIN ON/WHERE Operators
	SQL JOIN Multiple Tables
	SQL UNION
	SQL INTERSECT
	SQL MINUS
	SQL VIEW

SQL IN, NOT IN.

Selection with IN, NOT IN

SQL IN operator is used in a where statement, giving you the ability to select rows where a column value exists in a given list of values.

IN Example:

MySQL, Oracle, SQL server, PostgreSQL:

SELECT ADDR_LINE, CITY, US_STATE_CD from addresses
       where US_STATE_CD IN ('CA', 'NY')

The result should be:

addr_line	city	us_state_cd
5325 N Sheridan Road	Aguanga	CA
3871 San Antonio Drive Indio	Agoura Hills	CA
2581 Richmond Terrace Staten Island	Mappleton	NY

NOT IN Example:

MySQL, Oracle, SQL server, PostgreSQL:

SELECT ISBN_NO, SHORT_DESC, PUBLISHER from bookstore  
WHERE publisher NOT IN ('Wrox','OReilly');

The result should be:

isbn_no	short_desc	publisher
0201703092	The Practical SQL, Fourth Edition	Addison Wesley
0672325764	Sams Teach Yourself XML in 21 Days, Third Edition	Sams Publishing
1590593413	Beginning J2EE 1.4: From Novice to Professional	Apress

This site aims to provide FREE programming training and technics.

Finnesand Data as site owner gives no warranty for the correctness in the pages or source codes.

The risk of using this web-site pages or any program codes from this website is entirely at the individual user.

Needed Tools for SQL