单选题

物流轨迹跟踪系统中若需获取前3条记录,以下哪种方式最高效?( )

conn = sqlite3.connect('logistics.db')
cursor = conn.cursor()
cursor.execute('''
    SELECT track_id, location, timestamp 
    FROM tracking 
    WHERE package_id = ? 
    ORDER BY timestamp DESC''', ('PKG12345',))
# 获取最新轨迹
latest_record = cursor.fetchone()

A

[cursor.fetchone() for _ in range(3)]

B

cursor.fetchmany(3)

C

cursor.fetchall()[:3]

D

循环调用fetchone()三次

赣ICP备20007335号-2