carfield.com.hkmisc.txt2024-09-14T13:01:40Z2024-09-14T13:01:40Z<br/>How to do limit resultset correctly - <a href="http://blog.jooq.org/2014/06/09/stop-trying-to-emulate-sql-offset-pagination-with-your-in-house-db-framework/">http://blog.jooq.org[..]ination-with-your-in-house-db-framework/</a> <br/><br/>Using function result as table - <a href="http://blog.jooq.org/2014/07/07/postgresqls-table-valued-functions/">http://blog.jooq.org[..]7/07/postgresqls-table-valued-functions/</a> <br/><br/>Sample of using pivot - <a href="http://blog.jooq.org/2014/08/05/are-you-using-sql-pivot-yet-you-should/">http://blog.jooq.org[..]/are-you-using-sql-pivot-yet-you-should/</a> and unpivot - <a href="http://blog.jooq.org/2016/01/18/impress-your-coworkers-by-using-sql-unpivot/">http://blog.jooq.org[..]ess-your-coworkers-by-using-sql-unpivot/</a> <br/><br/>Sample of using intersect - <a href="http://blog.jooq.org/2015/08/04/intersect-the-underestimated-two-way-in-predicate/">http://blog.jooq.org[..]the-underestimated-two-way-in-predicate/</a> <br/><br/>Using temp table, rownum, and CTE - <a href="http://javarevisited.blogspot.hk/2016/07/how-to-remove-duplicate-rows-from-table-SQL-database.html">http://javarevisited.blogspot.hk[..]licate-rows-from-table-SQL-database.html</a> <br/><br/><a href="http://www.sohamkamani.com/blog/2016/07/07/a-beginners-guide-to-sql/">http://www.sohamkamani.com[..]log/2016/07/07/a-beginners-guide-to-sql/</a> <br/><br/>10 Quick SQL Tips After Writing Daily in SQL for 3 Years - <a href="https://towardsdatascience.com/10-quick-sql-tips-after-writing-daily-in-sql-for-3-years-37bdba0637d0">https://towardsdatascience.com[..]ng-daily-in-sql-for-3-years-37bdba0637d0</a> <br/><br/>Free books - <a href="http://www.java67.com/2017/08/5-free-sql-books-for-beginners-and-experienced-pdf-download.html">http://www.java67.com[..]inners-and-experienced-pdf-download.html</a> <br/><br/>9 SQL tricks you may not know about - <a href="https://meganlieu.substack.com/p/9-sql-tricks-you-may-not-know-about">https://meganlieu.substack.com[..]om/p/9-sql-tricks-you-may-not-know-about</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2024-09-14T13:01:40Zjoin.txt2019-06-17T00:30:14Z2019-06-17T00:30:14Z<br/><a href="http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins">http://www.codeproject.com[..]33052/Visual-Representation-of-SQL-Joins</a> <a href="http://nosql.mypopescu.com/post/51770099382/sql-joins-visualized">http://nosql.mypopescu.com/post/51770099382/sql-joins-visualized</a> <br/><br/>With IN and subquery / or "top" like keywords - <a href="http://javarevisited.blogspot.com.au/2012/12/how-to-find-second-highest-or-maximum-salary-sql.html">http://javarevisited.blogspot.com.au[..]econd-highest-or-maximum-salary-sql.html</a> <br/><br/>Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot <br/>- <a href="https://dev.to/javinpaul/5-online-courses-to-learn-sql-and-database-for-beginners-best-of-lot-5533">https://dev.to[..]-database-for-beginners-best-of-lot-5533</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2019-06-17T00:30:14Zgrouping.txt2016-01-22T03:39:27Z2016-01-22T03:39:27Z<br/>There is way to drop the dummy aggregate function in group by - <a href="http://blog.jooq.org/2015/12/10/sql-group-by-and-functional-dependencies-a-very-useful-feature/">http://blog.jooq.org[..]onal-dependencies-a-very-useful-feature/</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2016-01-22T03:39:27ZProblem of SQL.txt2014-01-13T04:24:11Z2014-01-13T04:24:11Z<br/>A nice article to talk about problem of SQL. Although we probably need to live with SQL or abstraction of SQL (various OQL and ORM QL), it still nice to know about this<br/><br/><a href="http://www.oreillynet.com/lpt/a/6060">http://www.oreillynet.com/lpt/a/6060</a> <br/><br/>How to simulate column reuse, which is missing from standard SQL - <a href="http://blog.jooq.org/2014/01/06/the-sql-languages-most-missing-feature/">http://blog.jooq.org[..]/the-sql-languages-most-missing-feature/</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2014-01-13T04:24:11Ztime.txt2011-04-29T06:41:53Z2011-04-29T06:41:53Z<br/>Function that convert string to timestamp for mssql, oracle and sybase - <a href="http://connectsql.blogspot.com/2011/04/sql-server-basics-todate-function-in.html">http://connectsql.blogspot.com[..]ql-server-basics-todate-function-in.html</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2011-04-29T06:41:53Zxml.txt2011-01-11T00:46:00Z2011-01-11T00:46:00Z<br/>manipulate xml in sql server - <a href="http://www.15seconds.com/issue/050803.htm">http://www.15seconds.com/issue/050803.htm</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2011-01-11T00:46:00Zexcept.txt2009-03-21T10:54:47Z2009-03-21T10:54:47Z<br/>example of except keyword - <a href="http://sqlblog.com/blogs/louis_davidson/archive/2007/02/08/getting-the-difference-between-two-sets-of-like-data.aspx">http://sqlblog.com[..]rence-between-two-sets-of-like-data.aspx</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2009-03-21T10:54:47Zansi joining.txt2007-10-15T11:32:55Z2007-10-15T11:32:55Z<br/>A nice article about standard ANSI joining syntax:<br/><br/><a href="http://www.oracle.com/technology/oramag/oracle/01-nov/o61sql.html">http://www.oracle.com/technology/oramag/oracle/01-nov/o61sql.html</a> <br/><br/>Recognizing well known patterns involving outer joins will form a ground-level vocabulary for your further explorations of your data. This article examined syntax, surprises, and rules of thumb with respect to the usage of joins.<br/><br/><a href="http://www.onjava.com/lpt/a/4443">http://www.onjava.com/lpt/a/4443</a> <br/><br/>A blog with nice graphic show how join work - <a href="http://www.codinghorror.com/blog/archives/000976.html">http://www.codinghorror.com/blog/archives/000976.html</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2007-10-15T11:32:55Zsolve sudoku in sql.txt2007-06-13T15:34:34Z2007-06-13T15:34:34Z<br/>A very complicate TSQL sample... in my opinions: <a href="http://www.vsj.co.uk/articles/display.asp?id=540">http://www.vsj.co.uk/articles/display.asp?id=540</a> <br/><br/>Even more implementation - <a href="http://lambda-the-ultimate.org/node/2291">http://lambda-the-ultimate.org/node/2291</a> <br/><br/>which introduce some interesting function in vendor specific SQL, like Oracle MODEL - <a href="http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.htm#sthref1855">http://download-uk.oracle.com[..]erver.102/b14223/sqlmodel.htm#sthref1855</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>2007-06-13T15:34:34Z