SQL学习

    SELECT
        sum(if(ssmsum.t='40' or ssmsum.t='42',ssmsum.c,0))as dl,sum(if(ssmsum.t='41',ssmsum.c,0))as xg,sum(if(ssmsum.t>'0'and ssmsum.t<'7',ssmsum.c,0))as cx,sum(if(ssmsum.t between 8and 11or ssmsum.t between 18and 35,ssmsum.c,0))as rw
        FROM(
        SELECT LOG_TYPE_ID as t,count(*)c FROM SSM_USER_AUDIT sua WHERE date_format(sua.LOG_TIME,'%Y-%m-%d')between $P{START_TIME}and $P{END_TIME}GROUP BY sua.LOG_TYPE_ID
        )as ssmsum

时间内 多个 count

SELECT
	* 
FROM
	emp AS a 
WHERE
	1 > ( SELECT count( * ) FROM emp WHERE deptno =  a.deptno AND sal <  a.sal ) 
ORDER BY
	a.deptno,
	a.sal;
	
	

查询部门第一 或者倒数第一