sql - ORDERBY 'Incorrect Syntax' in Declare Statement -

sql - ORDERBY 'Incorrect Syntax' in Declare Statement -

i'm trying such simple task, yet it's driving me crazy how keeps failing.

declare @neighbour hierarchyid = (select [stpath] tmppath [dev].[tmp].[strategytable] t parentcode = 'top') order t.stkey desc;

i maintain getting error saying

msg 156, level 15, state 1, line 4 wrong syntax near keyword 'order'.

at same time, works without clause; like

declare @parent hierarchyid = (select [stpath] tmppath [dev].[tmp].[strategytable] t [parentcode] = 'top')

wtf.......

declare @neighbour hierarchyid = (select top 1 [stpath] tmppath [dev].[tmp].[strategytable] t parentcode = 'top' order t.stkey desc);

this should accomplish want.

sql sql-server sql-server-2008 sql-order-by