Support for ROW_NUMBER() OVER ... and QUALIFY

Avatar
Dan LaBar
  • 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).

Replies 5
Avatar
0
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.

Avatar
0
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
0
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
0
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
0
Anonymous

Teradata syntax is made.


Customer support portal powered by UserEcho