How to count a null Values From the Database...?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL

SQL-Server

, +

I have a Table with a CheckIn and CheckOut Fileds.
I want to Count a Total Attempt..

The Entrys will be like this..

SQL

CheckIn                      CheckOut
2011-09-29 17:27:59.653      2008-11-29 17:35:50.020
NULL                         2008-11-29 18:07:49.653
2008-11-29 17:27:59.653      NULL

When I try to count total attempt like

SQL

SELECT COUNT(CheckIn) From Attendance

Then it will be Resulted in Only 2

But actually my Requirement is that even if CheckIn is null and the CheckOut filed is contain any entry then it will be counted

so when i fire a query for counting total attempt then it will be resulted in 3 on above data..

Thanks in Advance..
Tejas Vaishnav

Posted 30-Sep-11 21:07pm

Tejas Vaishnav

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-09-30T21:24:00

Solution 1

Null values are not counted as entries - understandably - so the COUNT function ignores them.
Instead use '*':

SQL

SELECT COUNT(*) FROM Attendance

Posted 30-Sep-11 21:24pm

OriginalGriff

Comments

Tejas Vaishnav 1-Oct-11 4:18am

Thats why i ask a question..

Ganu Sharma · Answer 2 · 2011-10-07T20:39:00

Solution 2

Dear
Try this code.

SELECT COUNT(CheckIn) From Attendance where CheckIn is not null

SELECT COUNT(CheckOut) From Attendance where Checkout is not
null

Posted 7-Oct-11 20:39pm

Ganu Sharma

Updated 7-Oct-11 20:57pm

v2

Ganu Sharma · Answer 3 · 2011-10-07T20:55:00

Solution 3

You can use is null clause for checking

null value existence in table column or any variable.

Posted 7-Oct-11 20:55pm

Ganu Sharma