一句SQL,判断char列的值是否组成回文字符串

Table t has 2 columns: id INT; value CHAR(1); Column id starts from 0, increased by 1 each row Column value is a single character string Table t has at least 1 row String s is a palindrome when: s[i] = s[s.length - i - 1] for i = 0 … (s.length – 1) / 2 E.g.: a, aba, abba. Q: Write one SQL statement to check if the string composed of value of t ordered by id is a palindrome (case sensitive). Output “Y” or “N”.

with tmp as 
(
    (select (select count(1) from t1)-1-id as id,value from t1)
except
    (select id,value from t1)
)
select 
case when count(1)=0 
then 'Y' else 'N' end 
from tmp;

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

扫码关注云+社区

领取腾讯云代金券