Wednesday, June 17, 2020

Row_Number() continue in Union all query

SELECT ROW_NUMBER() OVER (ORDER BY ...) AS Sno
FROM (
    SELECT
    ...
    UNION ALL
    SELECT 
    ...
) AS T
ORDER BY Sno

No comments:

Post a Comment