www.carfield.com.hk misc.txt 2024-09-14T13:01:40Z 2024-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:40Z join.txt 2019-06-17T00:30:14Z 2019-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:14Z grouping.txt 2016-01-22T03:39:27Z 2016-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:27Z Problem of SQL.txt 2014-01-13T04:24:11Z 2014-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:11Z time.txt 2011-04-29T06:41:53Z 2011-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:53Z xml.txt 2011-01-11T00:46:00Z 2011-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:00Z except.txt 2009-03-21T10:54:47Z 2009-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:47Z ansi joining.txt 2007-10-15T11:32:55Z 2007-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:55Z solve sudoku in sql.txt 2007-06-13T15:34:34Z 2007-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