SAP HANA ROWID (SAP HANA "$rowid$")

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