Here's another - in my opinion - interesting issue.

I have the following table: 'Contracts', with a field 'Contract' (varchar(20)).

I'm trying to put all Contracts in groups, one group per different Contract, like this:

Id Contract1
1 SampleContract
4 SampleContract
5 SampleContract

Id Contract2
2 SampleContract2
3 SampleContract2


How do I achieve this? (Per 'Contract-group' it has to output a new <table>)

Thanks in advance!