How to use greater than in sql

How to use greater than in SQL.

Greater than in SQL query: The greater than  (>) is an operator on the SQL server. It is useful while displaying data from SQL Server. Sometimes user need to display the higher values then lower value. As this situation user can use grater than sign on SQL server.

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,ItemQuantity from ItemDetails where ItemPrice>'240'
Select ItemCode 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')

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

Greater than in sql server, in image: