フィールドの最大値を取得する方法

2016/9/1 (Thu)2017/12/9 (Sat)

"Shape_Length" = (SELECT MAX( "Shape_Length" ) FROM Japan) 
"Shape_Length" = (SELECT MAX( "Shape_Length") FROM Japan WHERE "PREF" = '北海道' )