SQL select last 100 rows and load them into data frame via pandas

Question

I'm using pandas to do some calculations with big data sets. I'm getting my data from a local sql-database. Now I want to select the last 100 rows of my sql table and load them into my dataframe.

df = pd.read_sql('SELECT TOP(100) * FROM testTable ORDER BY last_updated DESC', engine)

but it seems that my sql select command has the wrong syntax. Could you help me to correct my code?

Have you read https://stackoverflow.com/questions/4193705/sql-server-select-last-n-rows? — Zero, Feb 21 '18 at 12:51
select * from tbl_name order by id desc limit N; is the right command syntax — Erwin Schleier, Feb 21 '18 at 12:58
You absolutely need to tag and mention what RDBMS you are using (Postgres, MySQL, SQL Server, Sybase, Teradata, Oracle, etc.) as `TOP` and `LIMIT` differ among the SQL dialects. — Parfait, Feb 21 '18 at 14:57

score 0 · Answer 1 · edited Dec 19 '22 at 06:55

0

Try:-

df = pd.read_sql('SELECT TOP 100 * FROM testTable ORDER BY last_updated DESC', engine)

Brackets aren't used with TOP in some SQLs since every SQL (e.g POSTGRESQL, MYSQL, etc) has different syntax, this might be the problem perhaps

edited Dec 19 '22 at 06:55

Suraj Rao

29,388
11
94
103

answered Dec 19 '22 at 06:33

Devansh Gupta

47
6

SQL select last 100 rows and load them into data frame via pandas

1 Answers1