ST9jMCX2

1SELECT *
2FROM (
3    SELECT * FROM employee
4) AS employee
5GROUP BY employee.id 
6
7
8
9
10CREATE TABLE `servers` (
11  `server_id` int(11) UNSIGNED NOT NULL,
12  `user_id` int(12) NOT NULL,  
13  `status` enum('on','off') NOT NULL DEFAULT 'on',
14  `active` enum('yes','no') NOT NULL DEFAULT 'yes'
15) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
17PARTITION BY RANGE (`date`)
18(
19PARTITION p0 VALUES LESS THAN (1529418721) ENGINE=MyISAM,
20PARTITION p1 VALUES LESS THAN (1532010721) ENGINE=MyISAM,
21PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE=MyISAM
22);
23
24
25
26
27
28DELIMITER //
29DROP PROCEDURE IF EXISTS sp_last24;
30
31CREATE PROCEDURE sp_last24(IN checkId int(11))
32	BEGIN 
33		SELECT status FROM uptime_monitors_logs ; 
34	END //
35DELIMITER ;
36
37
38
39
40SELECT 
41    ordernumber,
42    SUM(quantityOrdered) AS itemsCount,
43    SUM(priceeach*quantityOrdered) AS total
44FROM
45    orderdetails
46GROUP BY ordernumber
47HAVING total > 1000;