您可以这样做：
SELECt t1.*FROM ( SELECt * FROM my_table ORDER BY value DESC LIMIT 1 OFFSET N -- Set your value for N here, N being 0-based) t1RIGHT OUTER JOIN ( SELECT null -- This will guarantee that you have at least one row) t2ON TRUE
您可以这样做：
SELECt t1.*FROM ( SELECt * FROM my_table ORDER BY value DESC LIMIT 1 OFFSET N -- Set your value for N here, N being 0-based) t1RIGHT OUTER JOIN ( SELECT null -- This will guarantee that you have at least one row) t2ON TRUE
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
