sql1="select  distinct SUBSTRING (name,3,8)  from profin_application "
cr.execute(sql1)
dict1=cr.fetchall()
i=0
l=len(dict1)
for i in range(l):
    print dict1[i][0]

python for循环