RosettaCodeData/Task/FizzBuzz/SQL/fizzbuzz-1.sql

9 lines
209 B
MySQL
Raw Permalink Normal View History

2015-02-20 00:35:01 -05:00
SELECT CASE
WHEN MOD(level,15)=0 THEN 'FizzBuzz'
WHEN MOD(level,3)=0 THEN 'Fizz'
WHEN MOD(level,5)=0 THEN 'Buzz'
ELSE TO_CHAR(level)
END FizzBuzz
FROM dual
CONNECT BY LEVEL <= 100;