河端善博 ブログ / SQL Server / PASSJ

SQL Server, .NET, PASSJ

  PASSJブログ :: ホーム :: 連絡をする :: RSS  :: ATOM :: Login
  941 投稿数 :: 112 ストーリー :: 1472 コメント :: 596 トラックバック

ニュース

Windows Live Alerts
My Yahoo!に追加
Add to Google dotnetnuke.jp
NPOPLUS.JP
MVP
PASSJ

記事のカテゴリ

過去の記事

カテゴリ

イメージギャラリ

.TEXT

INETA コミュニティ

MOM2005

MSMVP

PASSJ

SQL コミュニティ

セキュリティ TIPS

セキュリティのキホン

テスト

ブログ翻訳

多言語対応

.TEXT

INETA コミュニティ

MOM2005

MSMVP

PASSJ

SQL コミュニティ

セキュリティ TIPS

セキュリティのキホン

テスト

ブログ翻訳

多言語対応

ひとことでいうと、ロト6 ですね。

  • 数字は、1~43
  • 数字は重複しない
  • 抽出数は、6

SELECT N
FROM
    (
    SELECT TOP 6 N
    FROM
        (
        SELECT 1 AS N, newid() AS ID     UNION ALL
        SELECT 2 AS N, newid() AS ID    UNION ALL
        SELECT 3 AS N, newid() AS ID    UNION ALL
        SELECT 4 AS N, newid() AS ID    UNION ALL
        SELECT 5 AS N, newid() AS ID    UNION ALL
        SELECT 6 AS N, newid() AS ID    UNION ALL
        SELECT 7 AS N, newid() AS ID    UNION ALL
        SELECT 8 AS N, newid() AS ID    UNION ALL
        SELECT 9 AS N, newid() AS ID    UNION ALL
        SELECT 10 AS N, newid() AS ID    UNION ALL
        SELECT 11 AS N, newid() AS ID    UNION ALL
        SELECT 12 AS N, newid() AS ID    UNION ALL
        SELECT 13 AS N, newid() AS ID    UNION ALL
        SELECT 14 AS N, newid() AS ID    UNION ALL
        SELECT 15 AS N, newid() AS ID    UNION ALL
        SELECT 16 AS N, newid() AS ID    UNION ALL
        SELECT 17 AS N, newid() AS ID    UNION ALL
        SELECT 18 AS N, newid() AS ID    UNION ALL
        SELECT 19 AS N, newid() AS ID    UNION ALL
        SELECT 20 AS N, newid() AS ID    UNION ALL
        SELECT 21 AS N, newid() AS ID    UNION ALL
        SELECT 22 AS N, newid() AS ID    UNION ALL
        SELECT 23 AS N, newid() AS ID    UNION ALL
        SELECT 24 AS N, newid() AS ID    UNION ALL
        SELECT 25 AS N, newid() AS ID    UNION ALL
        SELECT 26 AS N, newid() AS ID    UNION ALL
        SELECT 27 AS N, newid() AS ID    UNION ALL
        SELECT 28 AS N, newid() AS ID    UNION ALL
        SELECT 29 AS N, newid() AS ID    UNION ALL
        SELECT 30 AS N, newid() AS ID    UNION ALL
        SELECT 31 AS N, newid() AS ID    UNION ALL
        SELECT 32 AS N, newid() AS ID    UNION ALL
        SELECT 33 AS N, newid() AS ID    UNION ALL
        SELECT 34 AS N, newid() AS ID    UNION ALL
        SELECT 35 AS N, newid() AS ID    UNION ALL
        SELECT 36 AS N, newid() AS ID    UNION ALL
        SELECT 37 AS N, newid() AS ID    UNION ALL
        SELECT 38 AS N, newid() AS ID    UNION ALL
        SELECT 39 AS N, newid() AS ID    UNION ALL
        SELECT 40 AS N, newid() AS ID    UNION ALL
        SELECT 41 AS N, newid() AS ID    UNION ALL
        SELECT 42 AS N, newid() AS ID    UNION ALL
        SELECT 43 AS N, newid() AS ID
        ) AS T1
    ORDER BY ID
    ) AS T2
ORDER BY N
投稿日時 : 2004年4月13日 17:51

コメントを追加

# すごいクエリー技 2004/04/13 18:07 Suzukiworks Web Log
クエリー技

# 1 ~ 43 までの数字をランダムに抽出するクエリー 2004/04/14 12:27 福井 厚のBlog (Atsushi Fukui's blog)
1 ~ 43 までの数字をランダムに抽出するクエリー

# 4月以降の著者別ベストコンテンツ一覧 2004/05/13 9:17 河端善博の .TEXT でウェブログ
4月以降の著者別ベストコンテンツ一覧

コメント

タイトル:
名前:
Url:
コメント: