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 "