SqlSQL leaningUC1 min read·Jul 26, 2017--ShareDo not use `OR` but using `UNION ALL`Get UC’s stories in your inboxJoin Medium for free to get updates from this writer.SubscribeSubscribeRemember me for faster sign in2. Leaning explain3. JOIN
UC·Oct 14, 2016當2047冇到？吳靄儀 2016 年 10 月 11 日袁國強說，基本法於2047年6月30日後仍具法律效力，因為「五十年不變」的時限字眼只出現於第5條，沒有說自動失效就可「推斷」為繼續有效。
UC·Jun 11, 2016對權利的分析：有權利就有義務？這時代人人高舉權利。打開報紙書籍、新聞報道、時政評論，都會見到有人引用「權利」為自己的立論辯護。即使年幼的小孩，也懂得向老師與家長爭取自己的權利。
UC·Apr 13, 2017Humble ?Humble is one of the critical factor driving your personal growth. I never refuse others to share their suggestions or knowledge as I truly…
Rohan Dutt·3d ago10 Metric-Decomposition Techniques Senior Data Analysts Use Before Presenting Variance to…Metric decomposition techniques to uncover variance drivers and deliver clear, actionable insights to leadershipA response icon1
Samuel Shaibu·Oct 3SQL Window Functions, Part 2: the frame you were already usingA running total reads a specific slice of rows called a frame, and you’ve been relying on a default one since lesson six, which works fine…
InThe Code FrontierbyEngineerX·Sep 12Master SQL Window Functions With Real World ExamplesStop writing SQL that just fetches data, start writing SQL that tells a story
The Turtle Code·Nov 6Statement vs PreparedStatement: The Hidden SQL Injection Problem Every Java Developer Should…Most Java developers learn about Statement and PreparedStatement early in their JDBC journey.
Vansh Baghel·Nov 2How to Scale PostgreSQL Reads and Writes: From Query Optimization to ShardingYour application generates 3,000 database reads and 200 writes per second. Requests are getting slower during busy periods, and the spare…
