Support for ROW_NUMBER() OVER ... and QUALIFY

Dan LaBar

12 years ago
updated 8 years ago
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

Newest first
Newest first Oldest first

Anonymous

11 years ago

Teradata syntax is made.

Reply Link

Dan LaBar

12 years ago

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.

Reply Link

Anonymous

12 years ago

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.

Reply Link

Dan LaBar

12 years ago

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!

Reply Link

Anonymous

12 years ago

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.

Reply Link