Home Forums Testing Center Question of the Day (QOD) Question of the Day for 08 Nov 2005 RE: Question of the Day for 08 Nov 2005

  • November 8, 2005 at 10:55 am

    #602847

    Only in SS2K5 can you use the TOP keyword with DELETE.  Wouldn't this work for any version (and still use TOP)?:

    DELETE customers FROM (SELECT TOP 10 * FROM customers ORDER BY DateAdd DESC)