MSSQL – SELECT bit polja koje nije sadržano u GROUP BY

Problem:

Želimo selektirati iz baze vrijednost nekog polja “bit”  (dakle, true/false) upotrebom GROUP BY, ali ne želimo grupirati po njemu.

Rješenje:

Pretvoriti bit u int.

SELECT MIN(CAST(aktivno AS INT)) AS aktivno FROM tbl_tablica GROUP BY id
This entry was posted on Thursday, May 8th, 2014 at 2:16 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.