本文介绍了SQL Server 2005中使用Distinct的问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
您好，我正在使用以下sql查询
hi all i am using following sql query
select distinct tblBusinessRatingandReviews.businessid, tblBusinessRatingandReviews.UserId,tblBusinessRatingandReviews.businessratingcreationdate as date FROM tblBusinessRatingandReviews inner join tblBusinesses on tblBusinessRatingandReviews.BusinessId = tblBusinesses.BusinessId
它产生的结果为
it produced result as
30 16 2010-01-29 13:43:21.640
30 16 2010-01-29 14:57:08.390
30 16 2010-01-29 15:00:33.060
看到我希望它不会显示重复的业务ID我该怎么做?
See i want it will not displayed duplicate business id how i do this?
Thanks in advance!
推荐答案
这篇关于SQL Server 2005中使用Distinct的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！