关闭

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

317人阅读 评论(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)

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:269217次
    • 积分:3603
    • 等级:
    • 排名:第9414名
    • 原创:93篇
    • 转载:53篇
    • 译文:2篇
    • 评论:23条
    最新评论