How Write Sub Query inside Where Condition in SQL Compact Edition4.0

I am trying to write sub-query inside a where condition in SQL Compact Edition 4.0 but am facing an error.

My query is

SELECT TOP 1 CASE WHEN [id] IS NULL THEN -1 ELSE [id] END  FROM [Cosumers]  WHERE Sort < (SELECT Sort FROM Cosumers WHERE id = 2)  ORDER BY Sort DESS  

https://stackoverflow.com/questions/66717875/how-write-sub-query-inside-where-condition-in-sql-compact-edition4-0 March 20, 2021 at 11:11AM