select max(id) from kkkk where length(id::varchar) =7;
select max(id) from kkkk where length(id::varchar) =8;
------------ method 1
select * from kkkk where length(id::varchar) =7;
select * from kkkk where length(id::varchar) =8;
---------------method 2
select
case when length(id::varchar) =7 then id end as "ids with 7 caracters",
case when length(id::varchar) =8 then id end as "ids with 8 caracters"
from kkkk
2条答案
按热度按时间evrscar21#
我已经通过使用以下查询解决了这个问题:
这个字符串返回我所要求的输出。
g0czyy6m2#
后数据库:
演示