如何从 SQL Server 中的值列表中进行选择

2021-12-19 00:00:00 sql-server select-query

我有一个非常简单的问题，我无法解决.我需要做这样的事情:

I have very simple problem that I can't solve. I need to do something like this:

select distinct * from (1, 1, 1, 2, 5, 1, 6).

有人可以帮忙吗??

编辑

数据来自我们的一位客户的文本文件.它完全没有格式化(它是一行很长的文本)，但在 Excel 中可能会这样做.但这对我来说并不实用，因为我需要在我的 sql 查询中使用这些值.每次需要运行查询时都这样做很不方便.

The data comes as a text file from one of our clients. It's totally unformatted (it's a single, very long line of text), but it may be possible to do so in Excel. But it's not practical for me, because I will need to use these values in my sql query. It's not convenient to do so every time I need to run a query.

推荐答案

获取一长串逗号分隔文本的不同值的最简单方法是使用 find an replace with UNION 以获得不同的值.

Simplest way to get the distinct values of a long list of comma delimited text would be to use a find an replace with UNION to get the distinct values.

SELECT 1
UNION SELECT 1
UNION SELECT 1
UNION SELECT 2
UNION SELECT 5
UNION SELECT 1
UNION SELECT 6

应用于您的逗号分隔文本的长行

Applied to your long line of comma delimited text

  • 找到并用 UNION SELECT
    • 替换每个逗号
  • 在语句前添加SELECT

您现在应该有一个有效的查询

You now should have a working query

相关文章