How to use min function in sql

How to use min function in SQL.

How to use min function in SQL: MIN is a one of Sql aggregate functions string. The MIN aggregate function is used to find the minimum value of the records. The MIN function is used with the SQL selection instruction. It can also be used with "SQL Select Where Command". The added SQL MIN function returns the minimum value.

Aggregate functions in sql with syntax:
         Select MIN[COLUMN_NAME] From [TABLE_NAME]

Example: Here is Price table

ItemName	ManufactureCompany	ExpiredDate	ItemSerialNo	ItemCategory	ItemQuantity	ItemPrice	ProductCountry
Samsung Mobile	Samsung	12/1/2050	S12345	Mobile	500	240	Korea
Samsung Pro	Samsung	12/1/2050	SP1234	Mobile	100	300	Korea
Samsung Headphone	Samsung	12/1/2053	SH2345	Headphone	50	50	Korea
iPhone	iPhone	12/1/2049	iP12345	Mobile	1000	500	United Stat
Apple Mobile	Apple	12/1/2049	A12345	Mobile	200	300	United Stat
Apple Computer	Apple	12/1/2050	A12343	Computer	200	400	United Stat
Apple Macbook	Apple	12/1/2050	AM2345	Macbook	50	600	United Stat
Dell Computer	DELL	12/1/2050	D02345	Computer	200	240	United Stat
Dell Laptop	DELL	12/1/2050	DL2345	Laptop	30	240	United Stat
Apple Laptop	Apple	12/1/2050	AL2345	Laptop	500	100	United Stat
Apple Headphone	Apple	12/1/2050	AH2345	Headphone	50	20	United Stat
Sony Camera	Sony	12/11/2050	SN2345	Camera	200	240	Japan
Sony Headphone	Sony	12/1/2050	SNH345	Headphone	500	50	Japan
Ascer Computer	Ascer	12/7/2050	AC2345	Computer	100	600	China
Borother Printer	Brother	12/1/2050	B12345	Printer	200	200	China
Ascer Printer	Ascer	12/7/2050	AP2345	Printer	200	150	China
Brother Photocopy	Brother	12/7/2050	BP2345	Printer	20	150	China

Aggregate functions in sql with examples :

Now,
     Select MIN(ItemPrice) As MinimumPrice from ItemDetails
Result:

MinimumPrice

20

  Select MIN(ItemQuantity) As MinimumPrice from ItemDetails

Result:

MinimumPrice

20

Aggregate functions in sql with examples,

With SQL Select Where Command :

  Select MIN(ItemQuantity) As MinimumQty from ItemDetails Where ItemCategory='Mobile'

Result:

MinimumQty

100

   Select MIN(ItemQuantity) As MinimumQty from ItemDetails Where ManufactureCompany='Samsung'

Result:

MinimumQty

50

MIN() Aggregate functions in sql with examples, On Video:

Aggregate functions in sql with examples on Image :





















     
     

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

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