DISTINCT 这个查询了为什么还有重复的数据呢

liaohongchu 发布于 2010-05-20 17:13， 783 次点击

SELECT DISTINCT
      , LoginLog.LoginIP, LoginLog.LoginTime,
      , , Member.LoginCount
FROM LoginLog INNER JOIN
      Company ON = INNER JOIN
      Member ON LoginLog.MemberID = Member.MemberID
WHERE ( > 0)
ORDER BY LoginLog.LoginTime DESC

语句不对吗?

3 回复

misswang2010-05-21 00:33

你没指明根据哪个字段去重复项

liaohongchu2010-05-21 09:09

能在说详细点吗

SELECT DISTINCT
      , LoginLog.LoginIP, LoginLog.LoginTime,
      , , Member.LoginCount
FROM LoginLog INNER JOIN
      Company ON = INNER JOIN
      Member ON LoginLog.MemberID = Member.MemberID
WHERE ( > 0)
ORDER BY LoginLog.LoginTime DESC

怎么指定的 DISTINCT

saitor2010-05-21 19:42

DISTINCT 对单列有用多列没用

DISTINCT 这个查询了 为什么还有重复的数据呢

DISTINCT 这个查询了为什么还有重复的数据呢