sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(12)

User_Group_Name IN('Technician','Engineer') AND UDAR。User_Record_No = TSD。User_Record_No AND UDAR。Division_Record_No IN(1) SELECT DISTINCT A。User_Record_No, B。Staff_No, B。Full_Name,B。Job_Title, SUM(working_hour) AS Working_Hours,SUM(ot) AS OT_HOURS, C。Period_Start_Date,C。Period_End_Date INTO #temp2 FROM Time_Sheet_Details A INNER JOIN User_Master B ON B。User_Record_No= A。User_Record_No INNER JOIN #temp C ON C。Time_Sheet_Dtl_Record_No = A。Time_Sheet_Dtl_Record_No GROUP BY A。User_Record_No, B。Staff_No,B。

Full_Name,B。Job_Title, C。Period_Start_Date,C。Period_End_Date HING COUNT(*) = DATEDIFF(d,C。Period_Start_Date,C。Period_End_Date)+1 Select A。User_Record_No,A。Staff_No,A。Full_Name,A。Job_Title ,A。Working_Hours,A。OT_HOURS,A。Period_Start_Date,A。Period_End_Date ,DM。Division_Code INTO #temp3 FROM #temp2 AS A INNER JOIN User_Data_Access_Right UDAR ON UDAR。User_Record_No = A。User_Record_No INNER JOIN Division_Master DM ON DM。Division_Record_No = UDAR。Division_Record_No SELECT * From #temp3 order by 1,7,8; Select Count(Distinct User_Record_No+Period_Start_Date+Period_End_Date) From #temp3 DROP TABLE #temp ,#temp2,#temp3

Top

我认为上面的语句在实现需求时并不是最简,效率最高的语句.

Top

各种查询技巧结合才能写出最高效的查询

在SQL中使用DISTINCT是代价比较高的查询方式

Top

微软不公布SQLserver2000中的函数:

print pwdcompare('helloworld', pwdencrypt('helloworld'))

print pwdcompare('hello', pwdencrypt('world'))

Top

pwdencrypt

密码加密？

有些什么作用，不明白

随机取出10条数据

select top 10 * from tablename order by newid()

Top

看君一张贴，胜看一天书。

Top

功能：

type vender pcs

电脑 A1

电脑 A1

光盘 B2

光盘 A2

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-12.html