SAP HANA ROWID (SAP HANA “$rowid$“)

SAP HANA ROWID:

范例一： Select "rowid" >6 and "rowid" < 10

范例二：

SELECT "

注意：只能使用"rowid "ROWID"都是错误的语法。

错误语法：

错误范例一:Select "rowid" >6 and rowid < 10

Could not execute 'Select "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" >6 and"ROWID" < 10

Could not execute 'Select "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 "