[GitHub] [superset] sfirke commented on issue #21027: DISTINCT command error Incorrect syntax near the keyword on SQLLab when connect MSSQL database

["sfirke (via GitHub)" <gi...@apache.org>]

sfirke commented on issue #21027:
URL: https://github.com/apache/superset/issues/21027#issuecomment-1414231940

   Nice sleuthing.  I wonder if this can be accommodated on the Superset side.  It looks like `SELECT DISTINCT TOP 1000 * FROM myTable` is supported and does what `SELECT TOP 1000 DISTINCT * FROM myTable` would do in other dialects?  If so, could Superset recognize that the dialect is SQL Server and thus insert the TOP 1000 after DISTINCT?
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org