select * from scott.emp where job='MANAGER' and sal2000; select * from scott.emp where job!='MANAGER' or sal2000; select *…
Spark-SQL 源代码
汇集 Spark-SQL 相关的电路原理图、PCB工程文件、单片机/FPGA源代码、数据手册与应用设计方案。
select empno 编号,ename 姓名,job 工作,sal 薪水 from scott.emp
select * from scott.emp;
select * from scott.emp where job='MANAGER'; select * from scott.emp where sal=1100; select * from scott.emp w…
select empno,ename,sal,mgr,sal+mgr from scott.emp
select distinct job from scott.emp
select empno,ename,job from scott.emp
select mgr, mgr-7800,sign(mgr-7800) from scott.emp;
select sum(sal) 薪水总和 from scott.emp;
select mgr, round(mgr/100,2),round(mgr/1000,2) from scott.emp;