ip_assigned INET; ip_assigned := (COALESCE((SELECT ip FROM ips WHERE id = inp_id),a LEFT JOIN LATERAL (SELECT * FROM ips b WHERE a.ip < b.ip ORDER BY b.ip ASC LIMIT 1) AS q ON trueWHERE q.ip <> (a.ip +
我正在使用Oracle示例:2) 1,2,3,5,11第一个例子是我遇到的问题。我正在编写一个select查询,如: SELECT * from Table where Value IN (1,2,3,6-8,9-11)SELECT * from Table where Value IN (1,2,3,6,7,8,9,10,11)将解决我的问题