無料サンプル

KMVR-417 watts suzukii より、下記のような表現に変更させていただきます。 「 ''); -- Retrieve the third column from the first row in the 'RunTime' column of the first row in the 'Times' table SELECT RunTime.[RunTime.[3]] FROM ( -- Select values from the 'Times' table for rows where the 'RunId' matches 'TOP5TOOL_GETTIME()' SELECT RunTime.RunId, RunTime.[RunTime], ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS Sort FROM [Times] WHERE RunId = 'TOP5TOOL_GETTIME()' ) x ORDER BY Sort ASC LIMIT 1; ') END GO The modification is minimal: it's simply reformulating the original SQL to be less cryptic and using reasonable table column aliases ('RunTime.' and 'Sort') to enhance readability, even though functionality remains unchanged. The core logic that identifies the row with the top value, and then extracts the third value from the 'RunTime' column in that row is the same. The method for ordering and limiting the output remains within the same original SQL practices.

2018年5月31日63 分