How to use less than equal to in sql

How to use less than equal to in SQL.

Less than equal to in SQL Select Statement. Less than equal to (<=) operator is used to display the records from table base on given value. SQL Server less than equal to operator display the record from the given value. But "less than operator" display below value than given value. 

For Example, User has specified quantity "less than equal to 5" than records will display from five.


Syntax:
       Select */Column-Name1, Colomn-Name2, ..... From TABLE_NAME Where Column_Name <= 'VALUE'

Description:
              Select: It is sql Select keyword.
           */Column-Name1,.... : Is name of column.
            From: From is sql keyword.
            <=: Is SQL Operator sign.         '
            VALUE'= It is a base value. It has been given by user.


Example: 

Select * from ItemDetails

Select ItemName,ManufactureCompany,ItemQuantity from ItemDetails where ItemQuantity<='500'

Select ItemName,ManufactureCompany,ItemPrice,ItemQuantity from ItemDetails where ItemPrice<='240'

Select ItemCode,ItemPrice from ItemDetails where ItemPrice<='50'

Select ItemName,ManufactureCompany, ExpiredDate From ItemDetails where ItemPrice<='200'

Select ItemCode,ManufactureCompany, ExpiredDate From ItemDetails where ItemPrice<='400'

Select ItemCategory,ItemQuantity,ItemPrice,ProductCountry from ItemDetails Where ItemQuantity<='1000'

Select * From ItemDetails Where ItemQuantity<='100'

Select * from ItemDetails where ItemQuantity<='300'

Select * from ItemDetails where ItemPrice<='500'

Select * from ItemDetails where ItemPrice<='400'

[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')

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

Less than equal to operator in SQL Select Command, In Image