티스토리 뷰

공부

[Hive] `ROW_NUMBER()` without `ORDER BY`

승가비 2020. 6. 7. 16:08
728x90
SELECT
    ROW_NUMBER() OVER(ORDER BY (SELECT 0)) index,
    data
FROM table

https://www.mytecbits.com/microsoft/sql-server/row-number-without-using-order-by

 

Row Number Without Using Order By In SQL Server | My Tec Bits

How to generate row number without using ORDER By clause in SQL Server. Simple technique to override the sequence ordering while using ROW_NUMEBR() function

www.mytecbits.com

 

728x90

'공부' 카테고리의 다른 글

[Java] Jackson ignore null `JSONInclude(Include.NON_EMPTY)`  (0) 2020.06.07
[SQL] not exists  (0) 2020.06.07
[JVM] Heap memory size  (0) 2020.06.07
[Zeppelin] set output limit size  (0) 2020.06.07
[HBase] Add column famliy  (0) 2020.06.07
댓글