SQL期末考题求助。100分
发布网友
发布时间:2023-04-01 07:18
我来回答
共1个回答
热心网友
时间:2023-10-03 19:29
1:select * from emp where deptno=20
2:select * from emp where ENAME LIKE 'MA%'
3:SELECT * FROM EMP ORDER BY JOB ASC
4:SELECT DEPTNO,COUNT(*) FROM EMP GROUP BY DEPTNO
5:select sal from emp where sal>(select max(sal) from emp where deptno=20)
试编写一个函数SumN(n)计算并返回s=1+2+...+n。(要求以n作为输入参数)
Declare @input int
--没时间写了.
while()