for step in range(100): print(step) sql = """select top 10000 Key_ID,Hospital_Name as '诊断入参' from Hospital_Record where Key_ID not in (select top {} Key_ID from Hospital_Record order by Key_ID) order by Key_ID;""".format(step*10000)
sqlserver里面怎么控制每次从一张表取得10000条数据直到取完为止(假设表里是一百万数据)
最新推荐文章于 2024-02-06 22:10:14 发布