I have a query that returns mutliple rows under certain circumstances, but I don't want it to do that. I'm trying to get only one from within the select.
I need help with the syntax.
'AB' AS appid,
top 1 (mft.atd_unique_cust_key AS parentid) --- this is where I need the syntax help