Python List/Tuple in MS SQL Query as Parameter

Sumaia Parveen Shupti answered on July 29, 2022 Popularity 1/10 Helpfulness 1/10

answer Python List/Tuple in MS SQL Query as Parameter

Comment

tup = tuple(df.SELLER_ID.unique())

sql = """select top 5 * from DB
where ven_cd IN {}""".format(tup)

ven = pd.read_sql_query(sql, conn)
ven.head()

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: python sql

Link to this answer
Share Copy Link

Contributed on Jul 29 2022

Sumaia Parveen Shupti

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.