Print (Ya Chen); Starry Sky

学习笔记 | 生活平淡又惊奇

使用Pandas来写SQL查询

2022.08.10

SELECT, WHERE, DISTINCT, LIMIT

image-1689258002514

多条件SELECT

image-1689258075019

ORDER BY

image-1689258091336

IN… NOT IN

image-1689258108280

GROUP BY, COUNT, ORDER BY

image-1689258132897

HAVING

image-1689258150118

Top N records

image-1689258171855
image-1689258184660

MIN, MAX, MEAN

image-1689258204295
image-1689258212359
image-1689258229601

JOIN

image-1689258252310

UNION ALL and UNION

image-1689258268486

INSERT

image-1689258285415

UPDATE

image-1689258304955

DELETE

image-1689258321240

△