Oracle 中这个sql语句怎么写?

[saintqiqi]

SELECT MAX(ID) AS NewID FROM TableA WHERE LEFT(ID,6) = '000000';
在Sql Server 下这样写没问题
但在Oracle下LEFT有错误

[hchxxzx]

SELECT MAX(ID) AS NewID FROM TableA WHERE substr(ID,1,6) = '000000';

[mathsword]

SELECT MAX(ID) NewID FROM TableA WHERE substr(ID,1,6) = '000000';

[saintqiqi]

自己up

[saintqiqi]

有谁知道不