我想修剪SQL中的名称。 例如,我的数据有一个名称为美国航空公司,与"美国航空公司"相同。 我期待着写一个sql查询
select customer_name, requests.
from Table1.
where code = "blue"
--输出:
American airlines 25
Alaska Airline 45
American airlines 6
寻找输出
American airlines 31
Alaska Airline 45
有人可以帮忙吗:) 谢谢
使用 replace 将 " 替换为 null
REPLACE(string1, string_to_replace, replacement_string)
例如
select replace(customer_name,'"','') as cusname ,sum(requests)
.....
group by cusname
你试过group by
sum
吗?
select replace(customer_name,'"','') as customer_name, sum(requests)
from Table1.
where code = "blue"
group by replace(customer_name,'"','');