Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

select count distinct multiple columns sql server

SELECT COUNT(DISTINCT (CHECKSUM(DocumentId,DocumentSessionId)) + CHECKSUM(REVERSE(DocumentId),REVERSE(DocumentSessionId)) )
FROM DocumentOutPutItems
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #select #count #distinct #multiple #columns #sql #server
ADD COMMENT
Topic
Name
6+1 =