Select Attribute_Name, Attribute_Value,
ROW_NUMBER() OVER (ORDER BY Attribute_Value) as Attribute_Value_Order
from (
SELECT Distinct 'A' as Attribute_Name, [A] as Attribute_Value
FROM TableA
) t
Select Attribute_Name='A', Attribute_Value,Attribute_Value_Order=ROW_NUMBER() OVER (ORDER BY A)
from (
SELECT Distinct A as Attribute_Value
FROM Table A
) t
getting invalid column @ ROW_NUMBER() OVER (ORDER BY A)
Select Attribute_Name='A', Attribute_Value,Attribute_Value_Order=ROW_NUMBER() OVER (ORDER BY Attribute_Value) from ( SELECT Distinct A as Attribute_Value FROM Table A ) t
Member
29 Points
200 Posts
read distinct values
Nov 16, 2018 09:46 PM|sushsudh|LINK
SELECT Attribute_Name='A',Attribute_Value=distinct(A), Attribute_Value_Order=ROW_NUMBER() OVER (ORDER BY A) FROM TableA
Distinct doesnot work there.
All-Star
122763 Points
9872 Posts
Moderator
Re: read distinct values
Nov 16, 2018 09:57 PM|limno|LINK
Select Attribute_Name, Attribute_Value,
ROW_NUMBER() OVER (ORDER BY Attribute_Value) as Attribute_Value_Order
from (
SELECT Distinct 'A' as Attribute_Name, [A] as Attribute_Value
FROM TableA
) t
Format your SQL query with instant sql formatter:
http://www.dpriver.com/pp/sqlformat.htm
Member
29 Points
200 Posts
Re: read distinct values
Nov 16, 2018 10:18 PM|sushsudh|LINK
Select Attribute_Name='A', Attribute_Value,Attribute_Value_Order=ROW_NUMBER() OVER (ORDER BY A)
from (
SELECT Distinct A as Attribute_Value
FROM Table A
) t
getting invalid column @ ROW_NUMBER() OVER (ORDER BY A)
All-Star
122763 Points
9872 Posts
Moderator
Re: read distinct values
Nov 19, 2018 01:51 AM|limno|LINK
Select Attribute_Name='A', Attribute_Value,Attribute_Value_Order=ROW_NUMBER() OVER (ORDER BY Attribute_Value)
from (
SELECT Distinct A as Attribute_Value
FROM Table A
) t
Format your SQL query with instant sql formatter:
http://www.dpriver.com/pp/sqlformat.htm