SQLize Online / PHPize Online  /  SQLtest Online

create table if not exists pc( code int primary key ,model varchar(50) ,speed smallint ,ram smallint ,hd real ,cd varchar(10) ,price DECIMAL(8,4)); insert into pc values (1, '1232', 500, 64, 5.0, '12x', 600.0000), (2, '1121', 750, 128, 14.0, '40x', 850.0000), (3, '1233', 500, 64, 5.0, '12x', 600.0000), (4, '1121', 600, 128, 14.0, '40x', 850.0000), (5, '1121', 600, 128, 8.0, '40x', 850.0000), (6, '1233', 750, 128, 20.0, '50x', 950.0000), (7, '1232', 500, 32, 10.0, '12x', 400.0000), (8, '1232', 450, 64, 8.0, '24x', 350.0000), (9, '1232', 450, 32, 10.0, '24x', 350.0000), (10, '1260', 500, 32, 10.0, '12x', 350.0000), (11, '1233', 900, 128, 40.0, '40x', 980.0000), (12, '1233', 800, 128, 20.0, '50x', 970.0000); SELECT * FROM pc ; -- DROP PROCEDURE DB.NEWP; -- DROP PROCEDURE NEWP; DELIMITER // CREATE PROCEDURE NEWP(speed_1 INT) BEGIN SELECT DISTINCT model ,speed ,ram ,hd ,cd ,price FROM pc WHERE speed <= speed_1; END;//DELIMITER ; CALL NEWP(500);