[dba-SQLServer] Null and DISTINCT

jwcolby jwcolby at colbyconsulting.com
Fri Sep 18 12:52:00 CDT 2009


I have a result set where I have a ton of records that are absolutely identical.  I am trying to do 
a DISTINCT but there is one field that is pulling a NULL.  Is it true that the NULL will prevent the 
DISTINCT from working in this case?

Any way around this?
-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list