Skip to Content
0
Former Member
Sep 26, 2011 at 10:37 AM

count the id based on null value in sql server

28 Views

hi

i want get the data from sql based on null value

my table

id date intime

8-- 2011-09-03 00:00:00.000-- 930

9 2011-09-03 00:00:00.000 930

1 2011-09-04 00:00:00.000 930

2 2011-09-04 00:00:00.000 930

4 2011-09-04 00:00:00.000 915

7 2011-09-04 00:00:00.000 930

8 2011-09-04 00:00:00.000 930

9 2011-09-04 00:00:00.000 930

1 2011-08-01 00:00:00.000 930

2 2011-08-01 00:00:00.000 NULL

4 2011-08-01 00:00:00.000 NULL

5 2011-08-01 00:00:00.000 NULL

6 2011-08-01 00:00:00.000 NULL

7 2011-08-01 00:00:00.000 NULL

8 2011-08-01 00:00:00.000 NULL

9 2011-08-01 00:00:00.000 930

1 2011-08-02 00:00:00.000 930

2 2011-08-02 00:00:00.000 NULL

4 2011-08-02 00:00:00.000 NULL

5 2011-08-02 00:00:00.000 NULL

6 2011-08-02 00:00:00.000 NULL

7 2011-08-02 00:00:00.000 NULL

8 2011-08-02 00:00:00.000 NULL

9 2011-08-02 00:00:00.000 930

1 2011-08-03 00:00:00.000 930

help me