SELECT distinct TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName 

SELECT top 3 distinct TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName 

SELECT distinct top 3  TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName

------解决方案--------------------

来晚了


------解决方案--------------------
探讨


SQL code
SELECT distinct top 3  TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName


------解决方案--------------------
SELECT distinct top 3  TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName  



------解决方案--------------------
探讨

引用:

SQL code
SELECT distinct top 3 TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName


+


------解决方案--------------------
探讨

SQL code
SELECT distinct top 3  TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName


------解决方案--------------------
这没办法的事,你要么改,要么再写一个
'SELECT distinct TOP '+@TotalRecordForPageIndex+' '+@ReturnFields+'
           FROM '+@TableName+' '+@Where



------解决方案--------------------
SQL code

'SELECT DISTINCT TOP '+@TotalRecordForPageIndex+' '+@ReturnFields+'
            FROM '+@TableName+' '+@Where

------解决方案--------------------
已经差不多了，过来混点分哈

------解决方案--------------------
  尼玛 就没希望拿分了