Untitled

Subsonic 3.0.0.3 getting distinct items on column name. ActiveRecord
CREATE TABLE [dbo].[CityDistancesMin](
    [Id] int identity(1,1) not null,
    [City1] [int] NOT NULL,
    [City2] [int] NOT NULL,
    [Car] [nvarchar](50) NOT NULL,
    [Distance] [int] NOT NULL,
CONSTRAINT [PK_CityDistancesMin] PRIMARY KEY CLUSTERED
(
    [Id] ASC
) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
ON [PRIMARY]

SqlQuery query = new Select(CityDistancesMinTable.City1Column)
    .From< CityDistancesMinTable>();
     query.Aggregates = new List<Aggregate> {
          new Aggregate(CityDistancesMinTable.City1Column, AggregateFunction.GroupBy)
     };