大家好, 我写了一个查询,并得到如下所示的Output,但我希望所有记录的WorkingHours< 48. 请帮助我.我只想要大胆的结果. 查询和输出如下.
Hi All, I wrote a query and I got an Output like below but I want all records whose WorkingHours <48. Please help me.I want only result which is bold. Query and Output is below.
SELECT OffEmail,EmployeeName,(Sum(DHours*60+DMinutes)-sum(MHours*60+MMinutes))/60 as WorkingHours,(Sum(DHours*60+DMinutes)-sum(MHours*60+MMinutes))%60 as WorkingMins from Attendance_Master where LoginTime between '2011-04-01 00:00:00.000' and '2011-05-01 00:00:00.000' group by OffEmail,EmployeeName输出 OffEmail员工姓名WorkingHours WorkingMins abhishek.gupta@apvtechnologies Abhishek Kumar Gupta 204 23 abhishek.mishra@apvtechnologies Abhishek Mishra 191 47 admin@apvtechnologies管理员24 0 ajay.singh@apvtechnologies Ajay Pratap Singh 219 41 amit.singh@apvtechnologies阿米特·库玛·辛格202 42 amit.tewari@apvtechnologies阿米特·特瓦里0 0 amresh.sahu@apvtechnologies Amresh Sahu 202 24 Anjum Jeelani 173 15
Output OffEmail EmployeeName WorkingHours WorkingMins abhishek.gupta@apvtechnologies Abhishek Kumar Gupta 204 23 abhishek.mishra@apvtechnologies Abhishek Mishra 191 47 admin@apvtechnologies Admin 24 0 ajay.singh@apvtechnologies Ajay Pratap Singh 219 41 amit.singh@apvtechnologies Amit Kumar Singh 202 42 amit.tewari@apvtechnologies Amit Tewari 0 0 amresh.sahu@apvtechnologies Amresh Sahu 202 24 Anjum.jeelani@apvtechnologies Anjum Jeelani 173 15
推荐答案SELECT OffEmail,EmployeeName,(Sum(DHours*60+DMinutes)-sum(MHours*60+MMinutes))/60 as WorkingHours,(Sum(DHours*60+DMinutes)-sum(MHours*60+MMinutes))%60 as WorkingMins from Attendance_Master where LoginTime between '2011-04-01 00:00:00.000' and '2011-05-01 00:00:00.000' group by OffEmail,EmployeeName having (Sum(DHours*60+DMinutes)-sum(MHours*60+MMinutes))/60 < 48
更多推荐
SQL Server中where子句中的累积条件
发布评论