无法显示唯一数据

本文介绍了无法显示唯一数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个桌子market_place_design，它有不同的市场和设计。 1设计存在于不同的市场。 我有另一个表temp只有列设计填写它。 现在加入表后我得到了单个设计的多个数据，而我只需要1个顶部（1）就可以了。 但是前1个如果我选择多个设计，则不起作用。

i have a table market_place_design which has different market places and designs. 1 design exists in different market places. I have another table temp which has only column design filled in it. Now after joining the tables i am getting multiple data for a single design whereas i need only 1 top(1) to be precise. But top 1 does not work if i am selecting multiple design.

推荐答案

试试这个： Try this: SELECT DISTINCT * FROM Tmp Tmp inner JOIN MARKET_PLACE_DESIGN_RELATION MPDR ON MPDR.MARKET_PLACE_DESIGN=Tmp.MarketDesign

http：/ /www.w3schools/sql/sql_distinct.asp [ ^ ]