SAP HANA ROWID:
范例一： Select "$rowid$",* from EMP where "$rowid$" >6 and "$rowid$" < 10
范例二：
SELECT "$rowid$" as ROW_ID,* FROM EMP
注意：只能使用"$rowid$",使用 $rowid$ "$ROWID$"都是错误的语法。
错误语法：
错误范例一:Select "$rowid$",* from EMP where "$rowid$" >6 and $rowid$ < 10
Could not execute 'Select "$rowid$",* from EMP where "$rowid$" >6 and $rowid$ < 10' in 3 ms 632 ?s . SAP DBTech JDBC: [7] (at 53): feature not supported: line 1 col 54 (at pos 53)
错误范例二: Select "$rowid$",* from EMP where "$rowid$" >6 and"$ROWID$" < 10
Could not execute 'Select "$rowid$",* from EMP where "$rowid$" >6 and "$ROWID$" < 10' in 4 ms 2 ?s . SAP DBTech JDBC: [260] (at 53): invalid column name: $ROWID$: line 1 col 54 (at pos 53)
SAP HANA取出前10条记录的方法：
方法一：SELECT TOP 10 * from EMP;
方法二：使用ROWID, SELECT * FROM EMP where "$rowid$" <=10