![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
ms sql
lzynihao
这个作者很懒,什么都没留下…
展开
-
select 1
SELECT MIN(time) FROM T2 WHERE EXISTS ( SELECT 1 FROM T1 WHERE T1.id=T2.id AND T1.name='lzy' ) SELECT MIN(time) FROM T2 WHERE EXISTS ( SELECT 0 FROM T1 WHERE T1.id=T2.原创 2012-07-20 13:32:21 · 343 阅读 · 0 评论 -
sql
sql 三目运算Update table_name set column = case when clumn='test' then 'test1' else 'test2' end原创 2017-09-25 16:16:43 · 293 阅读 · 0 评论