Ideone.com

fork download

copy

SELECT col_1, ROW_NUMBER() OVER(PARTITION BY col_1 ORDER BY col_1 DESC) FROM table_1 ORDER BY col_1

Success #stdin #stdout #stderr 0s 2964KB

stdin

copy

Standard input is empty

stdout

copy

Standard output is empty

stderr

copy

Error: incomplete SQL: SELECT col_1, ROW_NUMBER() OVER(PARTITION BY col_1 ORDER BY col_1 DESC) FROM table_1 ORDER BY col_1

https://ideone.com/ExnnxR

language:

SQLite (sqlite 3.27.2)

created:

visibility:

secret

Share or Embed source code

The brand new service which powers Ideone!

Widget for compiling and running the source code in a web browser!