order by in sql-server views

👤 علی ذوالفقار 📅 1402/10/09 07:10:44 👁️ 214 views

add offset 0 to force order by in view

SELECT 
	*
FROM 
	CTE
ORDER BY ID DESC 
OFFSET 0 ROWS