MSSQL – bit field & group by

Problem: Potrebno je izvršiti aggregate funkciju na bit polje zbog grupiranja, a da se pritom ne grupira po bit polju

Rješenje:

Potrebno je pretvoriti bit u integer na kojeg onda možemo primijeniti aggregate funkciju


min(CAST(prikaz AS int)) AS prikaz
This entry was posted on Thursday, June 29th, 2017 at 2:10 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.