[dba-SQLServer] Delete

Wil Wakely wilw31 at gmail.com
Sun Aug 7 22:06:23 CDT 2011


Is this a correct sql statement to delete the first 5 rows (oldest dates) of
a recordset for Access 2002? I'm new to SQL.

strSQL1 = "DELETE FROM rs WHERE TOP 5,  player=1 ORDER BY playdate ASC;"
DoCmd.RunSQL strSQL1

==wilw

-- 
===wil wakely
sunny san diego ca


More information about the dba-SQLServer mailing list