摘要：SELECT RowID,BaseDeptID,BaseDeptNameFROM( select RowID=ROW_NUMBER() OVER(PARTITION BY Affair_instance.BaseDeptID ORDER BY Affair_instance.BaseDeptID*RAND()), Affair_instance.BaseDeptID,MAX(Affair_instance.BaseDeptName) AS BaseDeptName from Affair_instance Where Affair_instance.IsDeleted=0 GROUP B... 阅读全文

摘要：SELECT * FROM [ProjectInfo]ORDER BY (CASE DepartmentName WHEN 'AAA' THEN 1 WHEN 'BBB' THEN 2 WHEN 'CCC' THEN 3 ELSE 4 END)GO 阅读全文