Sql select where command

Sql select where command

Sql select where: In Sql server select where statement is very important to extract the value or data from sql table. Sometime user need to display the specific record/data from sql table. For this propose user must use sql select where command. Without select where command user can't display specific record or data from sql table. As if user need to display the details of specific product. For this condition user have to use sql where condition.

Syntax:
Select */Column-name1, Column-name2, Column-name3.... From TABLE_NAME Where COLUMN_NAME OPERATOR 'VALUE'

Description:
   - Select: Select is a sql keyword.
   - */Column-name1....: Name of column which present in sql table.
   - From: From is sql keyword.
   - COLUMN_NAME: It is used to specify name column where user want to display the value.
   - OPERATOR: It is sql operator (=, >,<, >=,<=) . For more details Click here.
   - 'VALUE': What type of value user want to display. Means display the record from table base on this value.

Example:
Select * from ItemDetails 
Select * From ItemDetails Where ProductCountry='Korea'
Select * From ItemDetails Where ProductCountry='United Stat'
Select * from ItemDetails where ManufactureCompany='Samsung'
Select * from ItemDetails where ItemCategory='Mobile'
Select * from ItemDetails Where ReceivedDate='2025-12-11'
Select ItemName,ManufactureCompany,ItemQuantity from ItemDetails where ItemQuantity='500'
Select ItemName,ManufactureCompany,ItemQuantity from ItemDetails where ItemPrice='240'
Select ItemCode from ItemDetails where ItemPrice='50'
Select ItemName,ManufactureCompany,ItemSerialNo from ItemDetails where ItemCategory='Printer'
Select ItemCode,ItemName,ExpiredDate from ItemDetails where ManufactureCompany='DELL'
Select ItemCode,ItemName,ExpiredDate from ItemDetails where ManufactureCompany='Sony'
Select ItemCode,ItemName,ExpiredDate from ItemDetails where ManufactureCompany='Brother'

[Note: We have created and inserted values into sql table in previous topic. For more details Click here.
OR
Execute the follow command in your sql query window for executing above sql select where statement]
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Create Table ItemDetails

(

ItemCode int,

ItemName varchar(30),

ManufactureCompany varchar(50),

ExpiredDate date,

ItemSearialNo varchar (30),

ItemCategory varchar(30),

ItemQuantity int,

ItemPrice float,

ProductCountry varchar(30),

ReceivedDate date,

ItemImage image

)

Insert into ItemDetails values('1','Samsung Mobile','Samsung','12-10-2024','12-01-2050','S12345','Mobile','500','240','Korea','12-10-2025')
Insert into ItemDetails values('2','Samsung Pro','Samsung','12-10-2024','12-01-2050','SP1234','Mobile','100','300','Korea','12-10-2025')
Insert into ItemDetails values('3','Samsung Headphone','Samsung','12-10-2023','12-01-2053','SH2345','Headphone','50','50','Korea','12-10-2025')
Insert into ItemDetails values('4','iPhone','iPone','12-01-2024','12-01-2049','iP12345','Mobile','1000','500','United Stat','12-10-2025')
Insert into ItemDetails values('5','Apple Mobile','Apple','12-11-2024','12-01-2049','A12345','Mobile','200','300','United Stat','12-10-2025')
Insert into ItemDetails values('6','Apple Computer','Apple','12-02-2024','12-01-2050','A12343','Computer','200','400','United Stat','12-10-2025')
Insert into ItemDetails values('7','Apple Macbook','Apple','12-11-2024','12-01-2050','AM2345','Macbook','50','600','United Stat','12-10-2025')
Insert into ItemDetails values('8','Dell Computer','DELL','12-09-2024','12-01-2050','D02345','Computer','200','240','United Stat','12-10-2025')
Insert into ItemDetails values('9','Dell Laptop','DELL','12-09-2024','12-01-2050','DL2345','Laptop','30','240','United Stat','12-10-2025')
Insert into ItemDetails values('10','Apple Laptop','Apple','12-08-2024','12-01-2050','AL2345','Laptop','500','100','United Stat','12-10-2025')
Insert into ItemDetails values('11','Apple Headphone','Apple','12-12-2024','12-01-2050','AH2345','Headphone','50','20','United Stat','12-10-2025')
Insert into ItemDetails values('12','Sony Camera','Sony','12-11-2024','12-11-2050','SN2345','Camera','200','240','Japan','12-11-2025')
Insert into ItemDetails values('13','Sony Headphone','Sony','12-09-2024','12-01-2050','SNH345','Headphone','500','50','Japan','12-11-2025')
Insert into ItemDetails values('14','Ascer Computer','Ascer','12-09-2024','12-07-2050','AC2345','Computer','100','600','China','12-10-2025')
Insert into ItemDetails values('16','Borother Printer','Brother','12-09-2024','12-01-2050','B12345','Printer','200','200','China','12-10-2025')

Insert into ItemDetails (ItemCode,ItemName,ManufactureCompany,ProductDate,ExpiredDate,ItemSearialNo,ItemCategory,ItemQuantity,ItemPrice,ProductCountry,ReceivedDate) values('17','Ascer Printer','Ascer','12-09-2024','12-07-2050','AP2345','Printer','200','150','China','12-10-2025')
Insert into ItemDetails (ItemCode,ItemName,ManufactureCompany,ProductDate,ExpiredDate,ItemSearialNo,ItemCategory,ItemQuantity,ItemPrice,ProductCountry,ReceivedDate) values('18','Brother Photocopy','Brother','12-08-2024','12-07-2050','BP2345','Printer','20','150','China','12-10-2025')

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Executing sql select where statement in image: