level 1
Battlefieler
楼主
show databases;
SELECT * from student
where length(givenName) and length(familyName)=
(max(length(givenName) and length(familyName)));
show databases;
SELECT * from student
order by sum(length(givenName) and length(familyName)) desc
limit 1;
现在有一个table student,里面有id, givenName, familyName, 现在想要从这个表里找出名字总长度最长的,该怎么写query啊?我写的这两个都根本不行啊。(能顺便把存在NULL值的情况去掉吗?)
2018年09月08日 09点09分
1
SELECT * from student
where length(givenName) and length(familyName)=
(max(length(givenName) and length(familyName)));
show databases;
SELECT * from student
order by sum(length(givenName) and length(familyName)) desc
limit 1;
现在有一个table student,里面有id, givenName, familyName, 现在想要从这个表里找出名字总长度最长的,该怎么写query啊?我写的这两个都根本不行啊。(能顺便把存在NULL值的情况去掉吗?)