一个sql查询,该如何处理

2012-11-06

一个sql查询SQL codeSELECT distinct TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName

一个sql查询

SQL code

SELECT distinct TagName,AssesTypeID FROM KPI_PerformanceEvalua order by TagName

这样可以

SQL code

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

这样就出错，只加了个top 3
关键字 'distinct' 附近有语法错误。

[解决办法]

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 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
[解决办法]
已经差不多了，过来混点分哈
[解决办法]
  尼玛 就没希望拿分了

热点排行

asp.net

一个sql查询,该如何处理