如何从表中选择所有空值 [英] How To Select All Null Values From A Table

问题描述

美好的一天，我有一个简单的表格，包括星期一，星期二，星期三，星期四，星期五，一些列已经存在和缺席，但现在我想从表中选择所有缺席...



如何从表格中选择仅缺席。



感谢您宝贵的时间，我真的很欣赏

解决方案

假设你的表包含一个列出勤类型的位和它的值将是 1 =当前和 0 =缺席然后选择查询将是

  SELECT  *  FROM  dbo.AttendanceDetail  WHERE 出勤= 0 

Good day all, I have a simple table with columns for MONDAY, TUESDAYS, WEDNESDAYS, THURSDAYS, FRIDAYS some of the columns have present and absent but now I want to select all Absent from the table...

How can I select Only Absent from the table.

Thanks for your valued time, I really do Appreciate

解决方案

Hi,
Assuming that your table contains a Column Attendance type of bit and its value will be 1= Present and 0= Absent then the select query will be

SELECT * FROM dbo.AttendanceDetail WHERE Attendance=0

这篇关于如何从表中选择所有空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！