|
Archives of the TeradataForumMessage Posted: Wed, 10 Feb 2016 @ 09:37:53 GMT
SELECT * FROM ( SELECT D.*,RANK() OVER (ORDER BY KY) AS RNK FROM ( SELECT * FROM (SELECT 1000 AS KY) A UNION SELECT * FROM (SELECT 1009 AS KY) A UNION SELECT * FROM (SELECT 1005 AS KY) A UNION SELECT * FROM (SELECT 1100 AS KY) A UNION SELECT * FROM (SELECT 1010 AS KY) A UNION SELECT * FROM (SELECT 1006 AS KY) A ) D ) E WHERE E.KY IN (1000,1006,1010)
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||