SQLでFIZZBUZZ（Oracle限定）

gistfile1.sql

WITH
  rowno AS (
    SELECT
      rownum no,
      mod(rownum, 3) mod3,
      mod(rownum, 5) mod5
    FROM
      dual
    CONNECT BY
      rownum < 16
  ),
  fb AS (
    SELECT no, 'fizzbuzz' AS fizzbuzz FROM rowno WHERE mod3 = 0 AND mod5 = 0
  ),
  fi AS (
    SELECT no, 'fizz' AS fizzbuzz FROM rowno WHERE mod3 = 0
  ),
  bu AS (
    SELECT no, 'buzz' AS fizzbuzz FROM rowno WHERE mod5 = 0
  )
SELECT
  rowno.no || fi.fizzbuzz || bu.fizzbuzz AS answer
FROM
  rowno 
    LEFT JOIN
      fb ON rowno.no = fb.no
    LEFT JOIN
      fi ON rowno.no = fi.no
    LEFT JOIN
      bu ON rowno.no = bu.no
ORDER BY
  rowno.no
;