Direct UPDATE TOP statements do not support an ORDER BY clause. To update specific rows (like the "top 10" based on date), developers often use Common Table Expressions (CTEs). Best Practices for Data Updates