33 - 连续出现的数字 -- 开窗函数lead(col,n) 统计窗口内往下第n行值
-- over(partition by xxx) 按照xxx所有行进行分组
-- over(partition by xxx order by aaa) 按照xxx分组,按照aaa排序select distinct num as ConsecutiveNums
from(select num,# 从当前记录获…
Section A Networking 网络 The need to share information and resources among different computers has led to linked computer systems, called networks, in which computers are connected so that data can be transferred from machine to machine. 不同计算机之间共享…
1、搭建网络
搭建网络拓扑、分配IP地址、划分网段、连接端口 2、配置路由器
路由器基础配置
//进入全局配置模式
Router#enable
Router#conf t
Enter configuration commands, one per line. End with CNTL/Z.//配置高速同步串口serial2/0
Router(config)#int ser2/0
Route…