How to use not in sql server

NOT IN keyword in SQL Query: NOT IN keyword ignore the selected value(s) and display records.

IN Keyword in SQL Server:
Syntax:
         Select [*|COLUMN_NAME,...] From [TABLE_NAME] Where NOT IN('VALUE','VALUE2',...)

Description:
             Select: SQL Keyword.
             * | COLUMN_NMME: All or specific column name.
             From: SQL Keyword.
             TABLE_NAME: Name of table.
             Where: SQL keyword.
            [NOT IN]: SQL Keyword.

Here is a Table ItemDetails

ItemCode	ItemName	ManufactureCompany	ItemSerialNo	ItemCategory	ItemQuantity	ItemPrice	ProductCountry
1	Samsung Mobile	Samsung	S12345	Mobile	500	240	Korea
2	Samsung Pro	Samsung	SP1234	Mobile	100	300	Korea
3	Samsung Headphone	Samsung	SH2345	Headphone	50	50	Korea
4	iPhone	iPone	iP12345	Mobile	1000	500	United Stat
5	Apple Mobile	Apple	A12345	Mobile	200	300	United Stat
6	Apple Computer	Apple	A12343	Computer	200	400	United Stat
7	Apple Macbook	Apple	AM2345	Macbook	50	600	United Stat
8	Dell Computer	DELL	D02345	Computer	200	240	United Stat
9	Dell Laptop	DELL	DL2345	Laptop	30	240	United Stat
10	Apple Laptop	Apple	AL2345	Laptop	500	100	United Stat
11	Apple Headphone	Apple	AH2345	Headphone	50	20	United Stat
12	Sony Camera	Sony	SN2345	Camera	200	240	Japan
13	Sony Headphone	Sony	SNH345	Headphone	500	50	Japan
14	Ascer Computer	Ascer	AC2345	Computer	100	600	China
16	Borother Printer	Brother	B12345	Printer	200	200	China
17	Ascer Printer	Ascer	AP2345	Printer	200	150	China
18	Brother Photocopy	Brother	BP2345	Printer	20	150	China
19	Brother Multi Printer	Brother	BM243	Photocopy	NULL	NULL	India

Now

Select ItemCode,ItemName,ManufactureCompany,ItemPrice from ItemDetails Where ManufactureCompany NOT IN('Samsung','Apple','DELL')

Result:

ItemCode	ItemName	ManufactureCompany	ItemPrice
4	iPhone	iPone	500
12	Sony Camera	Sony	240
13	Sony Headphone	Sony	50
14	Ascer Computer	Ascer	600
16	Borother Printer	Brother	200
17	Ascer Printer	Ascer	150
18	Brother Photocopy	Brother	150
19	Brother Multi Printer	Brother	NULL

Select ItemCode,ItemName,ItemCategory,ProductCountry from ItemDetails Where ItemCategory NOT IN('Mobile','iPhone')

Result:

ItemCode	ItemName	ItemCategory	ProductCountry
3	Samsung Headphone	Headphone	Korea
6	Apple Computer	Computer	United Stat
7	Apple Macbook	Macbook	United Stat
8	Dell Computer	Computer	United Stat
9	Dell Laptop	Laptop	United Stat
10	Apple Laptop	Laptop	United Stat
11	Apple Headphone	Headphone	United Stat
12	Sony Camera	Camera	Japan
13	Sony Headphone	Headphone	Japan
14	Ascer Computer	Computer	China
16	Borother Printer	Printer	China
17	Ascer Printer	Printer	China
18	Brother Photocopy	Printer	China
19	Brother Multi Printer	Photocopy	India

Select ItemCode,ItemName,ItemPrice,ProductCountry from ItemDetails Where ItemPrice NOT IN('500','600')

Result:

ItemCode	ItemName	ItemPrice	ProductCountry
1	Samsung Mobile	240	Korea
2	Samsung Pro	300	Korea
3	Samsung Headphone	50	Korea
5	Apple Mobile	300	United Stat
6	Apple Computer	400	United Stat
8	Dell Computer	240	United Stat
9	Dell Laptop	240	United Stat
10	Apple Laptop	100	United Stat
11	Apple Headphone	20	United Stat
12	Sony Camera	240	Japan
13	Sony Headphone	50	Japan
16	Borother Printer	200	China
17	Ascer Printer	150	China
18	Brother Photocopy	150	China

SQL NOT IN Keyword Example in Video

SQL NOT IN Keyword Example in Image