SQL简单语法

Group by & Distinct

筛选唯一的并分类

• 项目唯一并筛选后分组排序

select name, num, room, use, type, COUNT(name) from table a where  (a.name , a.num)  in (
		SELECT name, num FROM table` 
     WHERE type ='商业') AND (room LIKE '%其他%' AND  use ='用途') 
		 GROUP BY name, num 
		 ORDER BY COUNT(name) DESC	

BETWEEN

时间段

SELECT * FROM table
WHERE id in (SELECT ro_id from table_d d WHERE d.d_sta = 0 and time BETWEEN '2021-06-27' and '2021-07-04')