Unpivot no MySql

[thtrassi]

Olá galera, beleza?

Bom, quero a ajuda no seguinte item abaixo aonde tento trazer os número mais sorteados (10) e da erro. Pra ser bem sincero eu usava esse código no Firebird e funcionava normalmente, mas como estou me aventurando no MySql gostaria de fazer funcionar esse código.

 

public DataTable getResultadosMaisSorteados_Dez()
        {
            Cmd.CommandText = @"with CTE_Unpivot as
                                (    
                                    select cl_1 as dezena from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_2 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_3 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_4 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_5 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_6 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_7 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_8 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_9 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_10 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_11 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_12 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_13 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_14 from thsoftwares02.concurso_lotofacil
                                    union all
                                    select cl_15 from thsoftwares02.concurso_lotofacil
                                )

                                select first 10
                                    Dezena,
                                    COUNT(*) as Qtd
                                from CTE_Unpivot
                                group by
                                    Dezena
                                order by
                                    Qtd desc";

            DataTable dt = ExecutaSelect();
            return dt;
        }

[Flechaus]

Olá thtrassi, Tudo bem?

Este é um fórum de MySQL, e você deveria ter postado somente os comandos do mysql.

Com relação ao erro que ocorre, creio que o mysql não suporta o "first 10", por favor pesquise sobre a cláusula "Limit" nos manuais do mysql.

Um abraço.