如何在 SQL 中请求一个随机列? [英] How to request a random column in SQL?

问题描述

如何在纯 SQL 中请求随机列(或尽可能接近真正随机)?

How can I request a random column (or as close to truly random as is possible) in pure SQL?

我想从表中随机选择一列.

I want to select any one column randomly from a table.

我在谷歌上搜索了很多关于这个的内容.

I have searched lot regarding this on google.

推荐答案

USE [AdventureWorksDW2012]
GO

DECLARE @SQL VARCHAR(MAX)

SELECT  [name]
FROM    sys.columns C WHERE C.object_id = OBJECT_ID('DimProduct')
AND     C.column_id = (
SELECT  ((ABS(CHECKSUM(NEWID()))% COUNT(*)) + 1)
FROM    sys.columns C 
WHERE   C.object_id = OBJECT_ID('DimProduct'))

这可能对您有所帮助，它是通过 SQL Server 完成的.这里你随机选择表[DimProduct]

This may help you, It is done with SQL Server. Here you are randomly selecting a column of table [DimProduct]

结果 1:

结果 2:

这篇关于如何在 SQL 中请求一个随机列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！