SQL 语句 学习

2030阅读 0评论2016-12-13 Oliver_L_Oliver
分类:Mysql/postgreSQL

SELECT user, sum(first)  as sum_first , sum(last) as sum_last from zabbix.wpsuser_data group by user;


SELECT user, count(user)  as count_user from zabbix.wpsuser_data group by user;

SELECT *  from zabbix.wpsuser_data where user=0;

SELECT user,count(user) from zabbix.wpsuser_data WHERE first BETWEEN '1481126400' AND '1481212799' group by user;
上一篇:进程间通信方式及具体案例实现
下一篇:mysql-5.7.17-winx64 win10 安装指南 和 修改root 密码