WITH a1 AS (SELECT * ,ROW_NUMBER() OVER (ORDER BY CLIENT_ID DESC,CNAME DESC ) AS a2
FROM client)
SELECT * FROM a1
WITH a1 AS (SELECT * ,ROW_NUMBER() OVER (ORDER BY CLIENT_ID DESC,CNAME DESC ) AS a2
FROM client)
SELECT * FROM a1