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

2020-11-30 09:51:23 浏览数 (1)

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 "

0 人点赞