概述
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;
最后
以上就是俊秀树叶为你收集整理的一句SQL,判断char列的值是否组成回文字符串的全部内容,希望文章能够帮你解决一句SQL,判断char列的值是否组成回文字符串所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
发表评论 取消回复