1、if( b >'80')
SELECT NAME,SUM(a)
FROM table
WHERE to_number(b)>80
GROUP BY NAME
if( b>'80')不存在的 取 (b<'40')
SELECT NAME,SUM(a)
FROM table
WHERE to_number(b)<40
GROUP BY NAME 2、if( b >'80')
SELECT NAME,SUM(a)
FROM table
WHERE b>80
GROUP BY NAME
if( b>'80')不存在的 取 (b<'40')
SELECT NAME,SUM(a)
FROM table
WHERE b<40
GROUP BY NAME 应该可以的。
SELECT NAME,SUM(a)
FROM table
WHERE to_number(b)>80
GROUP BY NAME
if( b>'80')不存在的 取 (b<'40')
SELECT NAME,SUM(a)
FROM table
WHERE to_number(b)<40
GROUP BY NAME 2、if( b >'80')
SELECT NAME,SUM(a)
FROM table
WHERE b>80
GROUP BY NAME
if( b>'80')不存在的 取 (b<'40')
SELECT NAME,SUM(a)
FROM table
WHERE b<40
GROUP BY NAME 应该可以的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货