1

Closed

Wrong SQL generated when using both Distinct and Top n in one query

description

Hi When I use both Distinct and Top n rows in a query, the SQL generated is of the form

"SELECT TOP 20 DISTINCT * "

This causes a syntax error as the expected value is

"SELECT DISTINCT TOP 20 *"/
Closed Oct 18, 2013 at 11:46 PM by crpietschmann

comments