SELECT TOP 100 * FROM Project_12345..Demography_Current ORDER BY NEWID()
with engine.connect() as conn: df = pd.read_sql(""" SELECT TOP 100 * FROM Project_12345..Demography_Current ORDER BY NEWID() """, conn) df.head()
df <- dbGetQuery(conn, " SELECT TOP 100 * FROM Project_12345..Demography_Current ORDER BY NEWID() ") head(df)