Question

is possible do a case in a group by? similar to this:

select * from table

    GROUP BY 
      CASE WHEN @Attivita=0 THEN (RANK() OVER (GROUP BY Nome,AccountID,Matricola DESC))   

     END

感谢

Answer 1

无:这毫无意义。

页: 1

use GROUP BY and SELECT *
use RANK in a subclause
use GROUP BY in the OVER clause
GROUP BY over a ranking function makes no sense

你们试图做些什么,请投入/投入和计划。

Edit,根据gaby的答复

select
   *
from
    (
    SELECT
        *, RANK() OVER (GROUP BY Nome,AccountID,Matricola DESC) as bar
    from
        table
    ) foo
ORDER BY
   CASE WHEN @Attivita=0 THEN bar END

Answer 2

页: 1

如果您的<代码>选择*,你们都需要由大家共同组成......

以取代<代码> 页: 1 那么,你可以。

友情链接