ORACLE group by 可用函数

-
 AVG：平均值；
COUNT:行数；
MAX:最大值；
MIN:最小值；
STDDEV:标准偏差；
SUM:总计；
VARIANCE:方差；
分组会忽略null值

Comments

Post a Comment

Popular posts from this blog

Nginx Proxy & Load Balance & LNMP

-
Nginx Proxy Service E-commerce website Server 1: provide image request response (  apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / {      proxy_pass http://192.168.199.187:80/; } location /bbs/ {      proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$  {      proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / {      proxy_pass  http://192.168.199.187:80/;      proxy_set_header <parameter name>  $host;  (client requst the hostname )      proxy_set_header <parameter name> $remote_addr; ...
Read more

Linux RHCE Preparation

-
RHCE 1. Start classroom-rh254 2. Set environment: yum install ./examrhce-0.0.1-l.el7.x86_64.rpm -y 3. Start server-rh254 4. Set lab environment: lab examrhce setup 5. Start desktop-rh254 6.  Set lab environment: lab examrhce setup 7. Check result: lab examrhcsa grade 1. Set Selinux A. Change config file: vim /etc/sysconfig/selinux B. Temporary set selinux: setenforce 1 C. Check selinux: getenforce If it used to be disabled, you need to restart to change to enforcing.  2. SSH Access Setting A. Disable the firewall for RHEL 6 i. systemctl mask iptables; ii. systemctl mask ip6tables; iii systemctl mask ebtable.service B. Start the firewall for RHEL 7 i. systemctl enable firewalld ii. systemctl start firewalld C. Set firewall rule i. Allow ssh: firewall-cmd --permanent --add-service=ssh ii. Block subnet for ssh: firewall-cmd --permanent --add-rich-rul='rule family=ipv4 source address=172.17.10.0/24 service=ssh reject' D. Reloa...
Read more

Snort+barnyard2+Snorby CentOS 6.5_64 Installation

-
#download packages: daq-2.0.2.tar.gz ImageMagicK-6.8.9-8.tar.gz oinkmaster-2.0.tar.gz ruby-1.9.3-p547.tar.gz snort-2.9.6.2.tar.gz snortrules-snapshot-2962.tar.gz MySQL-server-5.5.40-1.rhel5.x86_64.rpm MySQL-client-5.6.21-1.rhel5.x86_64.rpm MySQL-devel-5.6.21-1.rhel5.x86_64.rpm MySQL-shared-5.6.21-1.rhel5.x86_64.rpm epel-release-6-8.noarch.rpm barnyard2-2.1.13.tar.gz #install yum package rpm -ivh epel-release-6-8.noarch.rpm yum install gcc-c++ patch readline readline-devel zlib zlib-devel flex git yum install libyaml-devel libffi-devel openssl-devel make  yum install bzip2 autoconf automake libtool bison iconv-devel libxml2-devel libxslt  yum install gcc g++ build-essential libssl-devel libreadline5-devel zlib1g-devel linux-headers-generic libsqlite3-devel libxslt-devel curl-devel sqlite-devel yum --enablerepo=epel install jasper jasper-libs jasper-devel #Mysql install yum remove mysql mysql-libs rpm -ivh MySQL-server-5.5.40-1.rh...
Read more