SQL server题目求解答2
发布网友
发布时间：2023-10-10 10:51
共1个回答
热心网友
时间：2024-12-11 22:51
你上边的create table dept…… 和 create table emp……就是答案
2
select '姓名:'+ename+'出生日期:+'convert(varchar(10),hiredate,120)+'工资:'+cast(sal as varchar) from emp
3
select a.ename+'’s manager is'+b.ename from emp a,emp b where a.MGR=b.empno
4
select ename from emp where LEN(ename)=(select MAX(LEN(ename)) from emp)
5
select CAST(SAL as varchar) from emp
select CONVERT(varchar,sal) from emp
6
SQL Server：datetime和date MySQL：datetime和date
7
仿造 insert into emp ……那些自己加吧
8
SQL Server：select getdate()
MySQL:select now()
9
select top 1 YEAR(hiredate) from emp group by YEAR(hiredate) order by COUNT(*) desc
10
select max(year(hiredate))-min(year(hiredate)) from emp
