Search
 
SCRIPT & CODE EXAMPLE
 

SQL

select count distinct multiple columns sql server

SELECT COUNT(DISTINCT (CHECKSUM(DocumentId,DocumentSessionId)) + CHECKSUM(REVERSE(DocumentId),REVERSE(DocumentSessionId)) )
FROM DocumentOutPutItems
Comment

PREVIOUS NEXT
Code Example
Sql :: sql group by example 
Sql :: mysql get only the field names in a table 
Sql :: postgresql where and 
Sql :: r write csv without index 
Sql :: restore backup "text" postgresql command line 
Sql :: list foreign key oracle 
Sql :: how to filter repeated same result using sql query 
Sql :: python get backup of sql 
Sql :: sql server update top n records 
Sql :: mysqli auto increment id 
Sql :: order by sql query 
Sql :: mysql max() 
Sql :: sql check if table exists 
Sql :: sql server set default value equal to auto increment 
Sql :: sql limit to 5 results 
Sql :: primary key sql 
Sql :: sql comments 
Sql :: sql create cluster index 
Sql :: sql rownum 
Sql :: SQL isnumeric DB2 
Sql :: mysql workbench download 
Sql :: mysql bind-address default value 
Sql :: how to average max mysql 
Sql :: sql delete just one row 
Sql :: how to check current root password in mysql 
Sql :: oracle datafile max size 32gb 
Sql :: SQL/delete 
Sql :: mysql group rows with same value 
Sql :: sql create database statement 
Sql :: mysql select field if condition 
ADD CONTENT
Topic
Content
Source link
Name
7+9 =