octzbear

摘要： sql server方式一：运行截图 sqlserver语句 1 declare @account nvarchar(20) 2 set @account = (select employee_ID from employee where employee_name='1'); 3 WITH per 阅读全文

摘要： 查找入职员工时间排名倒数第三的员工所有信息 select emp_no,birth_date,first_name,last_name,gender,hire_datefrom(select *,dense_rank() over(order by hire_date desc )as nfrom 阅读全文

摘要： 通过count（行数）可以取到0 withect1 as (select id from user where is_blacklist=0),ect2 as (select s1.id,s1.type,s1.date from email s1 where s1.send_id in ect1 a 阅读全文