Support for ROW_NUMBER() OVER ... and QUALIFY

Avatar
  • updated
  • Completed

Flyspeed SQL Query is a great product, but there are a few small annoyances.  Flyspeed doesn't seem to recognize an SQL statement like this:


ROW_NUMBER() OVER (PARTITION BY partitioncolnames ORDER BY ordercolnames)

I can successfully run the SQL if I don't click in the main (graphical) window first, but once I click in the main window it tries to format the SQL and turns it into a text statement.


It also doesn't like the QUALIFY clause (might be specific to Teradata).

Avatar
Anonymous

Teradata syntax is made.

Avatar
Dan LaBar

ROW_NUMBER() OVER... is not supported in my Teradata connection.  I did not think to try it in an Oracle connection, but I confirmed that it is supported for Oracle, as you say.  Thanks.

Avatar
Anonymous

Of course, we have support of ROW_NUMBER() syntax for Oracle database server. You may try to set the Oracle syntax for your Teradata connection, however I'm not sure if this will work for you.

Avatar
Dan LaBar

The ROW_NUMBER() syntax is also used in Oracle (not sure about other systems), so it is not specific to Teradata.


But yes, general Teradata syntax support would be great.


Thanks for making a great product!

Avatar
Anonymous

Generally speaking, you need support of Teradata SQL syntax? I can't promise you to implement this fast, but we already have this item in our to-do list.