sql to entity in 语句, top语句, exists语句的写法

select value top(1) T from TableName as T where T.ID >100

select value T from TableName as T where T.ID in ( select value E.ID from TableName1 as E where E.Name ='123' )

select value T from TableName as T where T.ID in {1,2,3}



select value T from TableName as T where T.Name like '%123%' and exists (select value E from T.TableName1 as E where E.ID=456)