sql - Can one use a correlated sub-query in Sybase ASE that has "TOP 1 column"? -

sql - Can one use a correlated sub-query in Sybase ASE that has "TOP 1 column"? -

i tried utilize proposed query on sybase ase 12, , complained syntax error.

select item, ( select top 1 tags.tag #tags tags left bring together t o on tags.tag = o.tag , o.item_id = n.item_id o.tag null order tags.tag ) 'tag', value t_new n

error: incorrect syntax near keyword 'top'.

however, same query worked when replaced (top 1 tag... order tag) max():

select item, ( select max(tags.tag) #tags tags left bring together t o on tags.tag = o.tag , o.item_id = n.item_id o.tag null -- order tags.tag ) 'tag', value t_new n

why using (top 1 tag... order tag) problem in sybase's correlated sub queries?

is there prepare original query not utilize min()/max()?

adaptive server enterprise version 12.5.3 supports top n clause in outer query select statements, not in select list of subquery. differs microsoft sql server. effort utilize top n clause adaptive server in subquery yields syntax error.

from ase 12.5.3 documentation here

sql subquery sybase-ase correlated-subquery