select empno,ename,sal,mgr,sal+mgr from scott.emp
LINQ to SQL 源代码
汇集 LINQ to SQL 相关的电路原理图、PCB工程文件、单片机/FPGA源代码、数据手册与应用设计方案。
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;
select mgr, power(mgr,2),power(mgr,3) from scott.emp;
select mgr, mod(mgr,1000), mod(mgr,100), mod(mgr,10) from scott.emp;
select min(sal) 最少薪水 from scott.emp;
select mgr, mgr/100,floor(mgr/100) from scott.emp;