SQL统计号码总数重复的算一个

怎么统计流水号的总数,重复的算一个
SELECT LSH AS 流水号 ,PATIENT_NAME AS 姓名, SAMPLE_NO AS 标本号,PATIENT_ID AS 病历号 ,BARCODE AS 条码号,CONVERT(varchar(100),SAMPLE_DATE , 111)as 时间 FROM TB_CURRENT_SAMPLE_INFO
WHERE INSTRUMENT='SLAN'
ORDER BY LSH,SAMPLE_DATE,SAMPLE_NO
这是语句 怎么加进去,谢谢

SELECT COUNT (1) AS LSH_SUM 
FROM (
    SELECT DISTINCT LSH
    FROM TB_CURRENT_SAMPLE_INFO) T

这个是单纯的计算流水号个数，也可以通过视图，关联查询

Group By 以后Sum