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

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。sql 查询四舍五入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

mark

Top

select * from a where time between time1 and time2

Top

让你们看看什么是SQL经典吧..

?id=928809

Top

select isNull(A.name,B.name),isnull(a.code,B.code) from table1 A

full out join table2 B on

A.id = B.id

Top

to cpp2017(长安不见使人愁)

jeff?

Top

SQL:SELECT NEWID()

Top

select a,b,c from tablename ta where a=(select max(a) from tablename tb where tb.b=ta.b)

选择在每一组b值相同的数据中对应的a最大的(换成average或别的函数或子查询,你会有意想不到的发现)记录的所有信息.

类似这样的用法可以用于论坛每月排行榜,每月热销产品分析,按科目成绩排名,等等.

上面的许多同志对子查询存在有偏见与误解,其实在一个好的数据分析程序中,子查询可以简化很多程序逻辑.

Top

上面select a,b,c from tablename ta where a=(select max(a) from tablename tb where tb.b=ta.b)

这种相关子查询和delete(insert)等结合起来,可以用于消除中某个字段(或某些)的重复值

Top

(select a from tableA ) except (select a from tableB) except (select a from tableC)

Top

获益不浅啊.

SELECT DISTINCT TSD。Time_Sheet_Dtl_Record_No,TSD。User_Record_No,TP。Period_Start_Date ,TP。Period_End_Date INTO #temp FROM Time_Sheet_Details TSD, Time_Sheet_Period TP ,User_Group_User_Relationship UGUR,User_Group_Master UGM ,User_Data_Access_Right UDAR WHERE TSD。status ='TS_WFMGRA' AND DATEDIFF(dd,TP。period_start_date,TSD。work_Date)>=0 AND DATEDIFF(dd,TP。period_end_date,TSD。work_Date)<=0 AND UGUR。User_Record_No = TSD。User_Record_No AND UGM。User_Group_Record_No=UGUR。User_Group_Record_No AND UGM。

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