Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH dado AS (
- SELECT 0 valore FROM DUAL
- UNION ALL
- SELECT 0 valore FROM DUAL
- UNION ALL
- SELECT 1 valore FROM DUAL
- UNION ALL
- SELECT 2 valore FROM DUAL
- UNION ALL
- SELECT 3 valore FROM DUAL
- UNION ALL
- SELECT 4 valore FROM DUAL
- ),
- lanci AS (
- SELECT dado1.valore,
- dado2.valore,
- dado3.valore,
- dado4.valore,
- dado5.valore,
- dado1.valore + dado2.valore + dado3.valore + dado4.valore + dado5.valore somma
- FROM dado dado1,
- dado dado2,
- dado dado3,
- dado dado4,
- dado dado5
- )
- SELECT somma,COUNT(*) occorrenze
- FROM lanci
- GROUP BY somma
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement