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

最新推荐文章于 2024-01-02 08:44:46 发布

WDYDXF

最新推荐文章于 2024-01-02 08:44:46 发布

阅读量896

点赞数

分类专栏： C# 备份文章

本文链接：https://blog.csdn.net/wdydxf/article/details/52349893

版权

备份文章同时被 2 个专栏收录

44 篇文章 0 订阅

订阅专栏

39 篇文章 0 订阅

订阅专栏

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)