摘要:
1、第一种写法 select id, case when p_id is null then "Root" when id not in (select distinct p_id from Tree where p_id is not null) then "Leaf" else "Inner" 阅读全文
摘要:
问题原因 待更新的目标表不能直接出现在from子句中; 错误写法 DELETE FROM Person WHERE id NOT IN ( SELECT min( id ) FROM person t1 GROUP BY email ) 正确写法(多封装一层) DELETE FROM Person 阅读全文
摘要:
初始数据 1、ROW_NUMBER() 序号连续但不重复; select *,row_number() OVER(order by number ) as row_num from num 注:在使用row_number() 实现分页时需要特别注意一点,over子句中的order by 要与SQL排 阅读全文