count the id based on null value in sql server

[Former Member]

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

[Former Member]

i got the solution