Database view group by clause
I created database view with using cmdb tables , I want to use gruop by cluase in Database views where clause like SQL . I think , where cluase does not support it .How do you solve this ? script or another method ?Regards, Thanks , Salih