SQL：少数列的 MS Access DISTINCT

发布于 2024-12-22 08:46:20 字数 211 浏览 0 评论 0原文

我有一个包含 250 列的表。我正在尝试选择所有列，但我想对两列使用 DISTINCT。

我的开始是这样的：

SELECT *
FROM table_name
WHERE EXISTS (SELECT DISTINCT table_name.column_name FROM table_name).

但是不起作用。也许有人有什么想法？提前致谢。

原文

I have a table with 250 columns. I'm trying to Select all columns, but I want to use DISTINCT for two columns.

My begin it's sometihing like that:

SELECT *
FROM table_name
WHERE EXISTS (SELECT DISTINCT table_name.column_name FROM table_name).

But doesn't work.
Maybe somebody has any ideas?
Thanks in advance.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

漫漫岁月 2024-12-29 08:46:20

SELECT * 
FROM table_name t
WHERE NOT EXISTS (SELECT 1 
                  FROM table_name tt 
                  WHERE tt.col1 = t.col1 
                    AND tt.col2 = t.col2 
                    AND tt.id > t.id)

SELECT * 
FROM table_name t
WHERE NOT EXISTS (SELECT 1 
                  FROM table_name tt 
                  WHERE tt.col1 = t.col1 
                    AND tt.col2 = t.col2 
                    AND tt.id > t.id)

回复收藏 0 原文

眸中客 2024-12-29 08:46:20

假设ID是表的主键，

SELECT *
FROM   table_name t
WHERE NOT EXISTS (SELECT 1 FROM table_name WHERE col1 = t.col1 AND ID <> t.ID)
  AND NOT EXISTS (SELECT 1 FROM table_name WHERE col2 = t.col2 AND ID <> t.ID)

Assuming ID is the primary Key of the Table,

SELECT *
FROM   table_name t
WHERE NOT EXISTS (SELECT 1 FROM table_name WHERE col1 = t.col1 AND ID <> t.ID)
  AND NOT EXISTS (SELECT 1 FROM table_name WHERE col2 = t.col2 AND ID <> t.ID)

回复收藏 0 原文

~没有更多了~