paradox 語法, 取得流水缺號 |
缺席
|
tooilxui
一般會員 發表:3 回覆:1 積分:0 註冊:2014-07-03 發送簡訊給我 |
select cast( substring( tireno2 from 7 for 8) as INTEGER) from pspec2 t1 where not exists ( select 1 from pspec2 t2 where substring( tireno2 from 7 for 8) = substring( t1.tireno2 from 7 for 8) ) order by 1 如果只下 select cast( substring( tireno2 from 7 for 8) as INTEGER) from pspec2 t1 order by 1 把where拿掉,就可以看到查詢結果如下:
系統時間:2024-04-20 17:43:11
聯絡我們 | Delphi K.Top討論版
|