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

Top

mark

Top

SQL:SELECT NEWID()

Top

????

没有深度 没兴趣

Top

我宁愿用冗余也不会使用子查询,除非万不得已

Top

自连接取出荣于数据

把所有姓名相同的只取出一个

select a.name from table_name a where a.id in

(select b.id from table_name b where a.id<>b.id)

同理删除荣誉数据

delete from table_namewhere table_name.id in

(select b.id from table_name b where table_name.id<>b.id)

Top

今天开眼界了啊，我就会select * from ** where **=**这一句

Top

利害...我会多一句

select top n * form ** where XXX

Top

不错，不错，

蛮喜欢junsisi(君三思)的这句：

select a.title,a.username,b.adddate from table a,(select max(adddate) adddate from table where table.title=a.title) b

对net_lover(孟子E章)前辈，这句不理解，我菜，呵呵

SQL:SELECT NEWID()

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。

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。

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