DwyanePeng的博客

滴滴笔试题order_list表：userid,orderid,start_timeselect userid,orderid from order_list awhere(select count(*) from order_list b where b.start_time<a.start_time)<=1 selectuserid,orderidf...

import pandas as pdimport osfrom read_pgdata import Postgredataroot_dir = r'root'file_names = os.listdir(root_dir)[:-1]print(len(file_names), file_names)pg = Postgredata()for i in range(len(...

select C.company_name,C.company_address from Companylist C left join "company_LoAndLa" L on C.company_name=L.company_name where L.company_name is null其他两种写法：select distinct A.ID from A where A.I...