2021-09-08

简单SQl

创建表

CREATE TABLE IF NOT EXISTS Employee (Id INT, Salary INT);

插入数据

INSERT INTO Employee (Id, Salary) VALUES ('1', '100');
INSERT INTO Employee (Id, Salary) VALUES ('2', '200');
INSERT INTO Employee (Id, Salary) VALUES ('3', '300');

查询第二高的薪水

SELECT * FROM Employee WHERE

Salary IN (SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (

SELECT  MAX(Salary) FROM Employee) )

创建表

CREATE TABLE IF NOT EXISTS Activity (user_id INT, session_id INT, activity_date DATE, activity_type ENUM('open_session', 'end_session', 'scroll_down', 'send_message'));
TRUNCATE TABLE Activity;

数据源
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('1', '1', '2019-07-20', 'open_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('1', '1', '2019-07-20', 'scroll_down');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('1', '1', '2019-07-20', 'end_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('2', '4', '2019-07-20', 'open_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('2', '4', '2019-07-21', 'send_message');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('2', '4', '2019-07-21', 'end_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('3', '2', '2019-07-21', 'open_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('3', '2', '2019-07-21', 'send_message');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('3', '2', '2019-07-21', 'end_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('3', '5', '2019-07-21', 'open_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('3', '5', '2019-07-21', 'scroll_down');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('3', '5', '2019-07-21', 'end_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('4', '3', '2019-06-25', 'open_session');
INSERT INTO Activity (user_id, session_id, activity_date, activity_type) VALUES ('4', '3', '2019-06-25', 'end_session');

 查询以查找截至2019年7月27日（含）的30天内每个用户的平均会话数，四舍五入到小数点后两位。我们只统计那些会话期间用户至少进行一项活动的有效会话

效果

JDK搭建

mkdir  /opt/software

mkdir/opt/module

解压文件到module

tar -zxvf jdk-8u212-linux-x64.tar.gz -C /opt/module/

        创建/etc/profile.d/my_env.sh文件

        vim /etc/profile.d/my_env.sh

        添加的内容

#JAVA_HOME

export JAVA_HOME=/opt/bdp/jdk1.8.0_212

export PATH=$PATH:$JAVA_HOME/bin

使代码生效

source /etc/profile.d/my_env.sh

查看是否安装成功

        java -version

        出现这个"java version "1.8.0_212" " 表示成功。