22,208
社区成员
发帖
与我相关
我的任务
分享
DECLARE @TMPTABLE TABLE ( ID INT NOT NULL)
DECLARE @IntID INT;
DECLARE @IntRowCount INT;
SET @IntID=0
SELECT @IntRowCount=COUNT(*) FROM Pro_PriceSet
WHILE @IntID<=5 BEGIN
INSERT INTO @TMPTABLE VALUES(RAND()* @IntRowCount)
SET @IntID=@IntID+1
END
SELECT * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY ProNum) AS RowNumber,* FROM Pro_PriceSet
) AS T WHERE RowNumber IN (SELECT TOP 5 ID FROM @TMPTABLE ORDER BY ID)
SELECT * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY ProNum) AS RowNumber,* FROM Pro_PriceSet
) AS T WHERE RowNumber IN (SELECT TOP 5 ID FROM @TMPTABLE ORDER BY ID)
SELECT * FROM table
WHERE num_value >= RAND() * (SELECT MAX(num_value) FROM table)
LIMIT 1;
SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1