WITH xbyte as (SELECT NULL as x FROM (VALUES (0),(0),(0),...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A for scientists using computers to solve scientific problems

WITH
xbyte as (SELECT NULL as x FROM (VALUES
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0),
    (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0), (0),(0),(0),(0)
) as t(x)),
x32int as (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) as x FROM xbyte b1, xbyte b2),
x64int as (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) as x
  FROM x32int i1, x32int i2)
 SELECT x FROM x32int WHERE x <= 100;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results