Excel使用技巧总结 秒速五厘米 2021-09-28 06:22 290阅读 0赞 1.生成sql语句里in后的部分(数据比较多的时候,使用下能提高效率) 有如下sql语句(有时,in后的内容很多) select * from student s where s.vc_name in ('张三','李四','王五','赵六','钱七'); ![20190304160620214.png][] ![20190304160713921.png][] ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTA5OTk4MDk_size_16_color_FFFFFF_t_70][] 参考链接:[https://jingyan.baidu.com/article/597a06430eb2d3312b5243a9.html][https_jingyan.baidu.com_article_597a06430eb2d3312b5243a9.html] 2.将去重的结果复制到另一列 ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTA5OTk4MDk_size_16_color_FFFFFF_t_70 1][] 操作后的结果: ![2019030416292123.png][] [20190304160620214.png]: /images/20210923/de13e7562d1f43aca668fcf3fc77a2b0.png [20190304160713921.png]: /images/20210923/528d00feccc3410596d762e3c02a5fe7.png [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTA5OTk4MDk_size_16_color_FFFFFF_t_70]: /images/20210923/a53e9753c93e4b839cc8ba3685cdd8ad.png [https_jingyan.baidu.com_article_597a06430eb2d3312b5243a9.html]: https://jingyan.baidu.com/article/597a06430eb2d3312b5243a9.html [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTA5OTk4MDk_size_16_color_FFFFFF_t_70 1]: /images/20210923/7cf04461487a453f899205888e7235f8.png [2019030416292123.png]: /images/20210923/6a48d3b09707446c8162385b14c016ab.png
还没有评论,来说两句吧...