search

red-soft-ru / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
0 stars 1 forks source link

T619 Nested window functions #64

Open TedCraft opened 1 month ago

TedCraft commented 1 month ago

You have an error in your SQL syntax: SELECT CUST_CODE CUST_NAME row_number() over (order by opening_amt) FROM CUSTOMER order by opening_amt no viable alternative at input '(' at line 1 position 48 near @948:48='('<29>1:48

TedCraft commented 4 weeks ago

SELECT CUST_CODE, CUST_NAME, row_number() over (order by opening_amt) FROM CUSTOMER order by opening_amt