alibaba

基础题：
1.销售表sales_dtl有城市(city)，销售经理(cbm)，客户(customer)，销售金额(sale_amt)三列字段，请用sql取出每个城市中销售金额为本城市前10名的销售经理的信息。

select
a.city
,a.cbm
,row_number() over (partition by a.city order by a.sum_sale desc) as rank
–如果并列第十名也算第十用rank
from
(
–获得每个销售经理的销售总额
select
city
,cbm
,sum(sale_amt) as sum_sale
from sales_dtl
group by city,cbm
)a
having rank<=10;

2.从一段字符串中,把所有长度大于5的回文子串打印出来,回文串指正向或反向读都一样(例如ABA,1221)。用自己擅长的语言来实现。
str1 = str(input())
def huiwen(s):
res = []
n = len(s)
dp = [[0] * n for _ in range(n)]
for i in range(n):
for j in range(i + 1):
if s[i] == s[j] and (i - j < 2 or dp[j + 1][i - 1]):
dp[j][i] = 1
#去重重复值
if i-j>4 and s[j:i+1] not in res:
print(s[j:i+1])
res.append(s[j:i+1])
return res
huiwen(str1)

3.实现一个回型矩阵，输入为边长n，输出一个n * n的回型矩阵。用自己擅长的语言来实现。
例如：给出边长4，输出为
1 2 3 4
12 13 14 5
11 16 15 6
10 9 8 7

#从外向内一圈一圈
n = int(input())
def huixing(n):
ans = [[0]*n for i in range(n)]
u = 0
d = n-1
t = 1
while u<d:
#上边
for i in range(u,d):
ans[u][i] = t
t += 1
#右边
for i in range(u,d):
ans[i][d] = t
t += 1
#下边
for i in range(d,u,-1):
ans[d][i] = t
t += 1
#上边
for i in range(d,u,-1):
ans[i][u] = t
t += 1
u += 1
d -= 1
if u==d :
ans[u][d] == t
return ans
print(huixing(n))