devxlogo

December 7, 2018

Selecting the Max, Min and Sum of Values from a Table in MySQL

Considering the following table STOCKPRICE and its details. CREATE TABLE ‘STOCKPRICE’ (‘ID’ INT(11) NOT NULL,’NAME’ TEXT NOT NULL COLLATE ‘utf8_bin’,’PRICE’ INT(11) NOT NULL)COLLATE=’utf8_bin’ENGINE=InnoDB; Also, use the following to create sample