• python
  • javascript
  • reactjs
  • sql
  • c#
  • java
Facebook Twitter Instagram
Devs Fixed
  • python
  • javascript
  • reactjs
  • sql
  • c#
  • java
Devs Fixed
Home ยป Resolved: How to pass python loop i to sql select top i number of rows

Resolved: How to pass python loop i to sql select top i number of rows

0
By Isaac Tonny on 17/06/2022 Issue
Share
Facebook Twitter LinkedIn

Question:

I am new to python and sql bear with my knowledge.
I want to run a query where I can get top (looped variable) while running sql in python compiler.
Eg
So that can get the top 1st row in first I loop and top 2nd row in next I loop and goes on. Please assist.

Answer:

You use string replacement as prepared statements will not work

If you have better answer, please add a comment about this, thank you!

pandas python snowflake-cloud-data-platform sql
Share. Facebook Twitter LinkedIn

Related Posts

Resolved: Using AWK to count multiple patterns in a file

01/04/2023

Resolved: significance letter above bar graphic in wrong order

01/04/2023

Resolved: VBA – Applying border around the areas with value/text

01/04/2023

Leave A Reply

© 2023 DEVSFIX.COM

Type above and press Enter to search. Press Esc to cancel.