<div>
<div class="content wysiwyg-content">
I have this table<br />
Id &nbsp; &nbsp;AId &nbsp; BId &nbsp;<br />
1 &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; 1<br />
2 &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; 1<br />
3 &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; 2<br />
4 &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; 2<br />
5 &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; 1<br />
6 &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; 2<br />
From this table I would like to group by 1) AId &nbsp; 2) BId<br />
So that I would get returned:<br />
AId &nbsp; &nbsp;BId<br />
1 &nbsp; &nbsp; &nbsp; &nbsp;1<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
How can I do this? &nbsp; &nbsp;
</div>
</div>


I have this table
Id    AId   BId  
1     1       1
2     1       1
3     1       2
4     1       2
5     2       1
6     2       2
From this table I would like to group by 1) AId   2) BId
So that I would get returned:
AId    BId
1        1
1         2
2         1
2         2
How can I do this?    

Group by - 2

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.