本文介绍了空值取代'缺席'? SQL查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 空值取代缺席如何? 这是我的查询 仅限一段时间out值为null,因此null值替换为AbsentNull value replace "Absent" how?this is my querysome time only in out value is null , so null value replace to "Absent"select distinctE.USERID as [رقم الموظف],U.User_FirstName+ ' ' + U.User_LastName as [اسم الموظف] ,CONVERT(Date,LOCALTIMESTAMP) as [تاريخ العمل],(select min(Convert (TIME,LOCALTIMESTAMP))from access_event_logs As MINCEwhere CAST(MINCE.LOCALTIMESTAMP as DATE)=CAST(E.LOCALTIMESTAMP As DATE) AND MINCE.EVENTID ='In' and MINCE.USERID=E.USERID) As [وقت الدخول],(select max(Convert (TIME,LOCALTIMESTAMP))from access_event_logs As MAXCEwhere CAST(MAXCE.LOCALTIMESTAMP as DATE)=CAST(E.LOCALTIMESTAMP As DATE) AND MAXCE.EVENTID ='Out' and MAXCE.USERID=E.USERID) As [وقت الخروج]from access_event_logs As E Inner join access_user as U on E.USERID = U.User_ID where Convert(date,LOCALTIMESTAMP) between '14/May/2014' And '14/May/2014'推荐答案select case when column1 is null then 'Absent' else column1 end from table1AND ISNULL(MAXCE.EVENTID, 'Absent') ='Out'或 orAND COALESCE(MAXCE.EVENTID, 'Absent') ='Out'select ISNULL(columnName,'What ever would you like to replace') from TableName 现在,你可以根据它修改它根据你的需要.. :))Now, You can modified it according to your need.. :) 这篇关于空值取代'缺席'? SQL查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!