MSSQL - SELECT DISTINCT

[Pavel Polívka]

Hi,

I need to use construction "SELECT DISTINCT" on MSSQL database. Is there any support (or will be) for this?
I can use workaround by using:
$table->select('DISTINCT table.column') which will generate: SELECT DISTINCT table.column FROM table

But the problem occurs, when I need to add limit:
$table->limit('10') which will generate: SELECT TOP(10) DISTINCT table.column FROM table
This SQL query has syntax error, because it should be: SELECT DISTINCT TOP(10) table.column FROM table

Thanks for any advices or information about this topic.

[Jakub Vrana]

You can use group() instead.

Jakub