阅读背景:

我是否需要GROUP BY中的此字段不显示重复的行

来源:互联网 

I am creating a query below where a it retrieves data depending on the term(s) the user entered in the a search bar. Now what I am trying to do is not display duplicate data, so if there are 2 rows where all the fields are exactly the same, then it is a duplicate row, so it only shows this row once not multiple times. Now I think it seems to do this as I see no duplicate rows but all I did was do a GROUP BY with all the SELECT fields except for the Answer field as it doesn't let me have a group concat in the GROUP BY clause.I am creating a query below where a it retrieve




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: