RSS feed [root] /database /weblog /sql




login:

password:

title search:




 


Mon Aug 21 15:40:53 HKT 2017

misc



How to do limit resultset correctly - http://blog.jooq.org[..]ination-with-your-in-house-db-framework/

Using function result as table - http://blog.jooq.org[..]7/07/postgresqls-table-valued-functions/

Sample of using pivot - http://blog.jooq.org[..]/are-you-using-sql-pivot-yet-you-should/ and unpivot - http://blog.jooq.org[..]ess-your-coworkers-by-using-sql-unpivot/

Sample of using intersect - http://blog.jooq.org[..]the-underestimated-two-way-in-predicate/

Using temp table, rownum, and CTE - http://javarevisited.blogspot.hk[..]licate-rows-from-table-SQL-database.html

http://www.sohamkamani.com[..]log/2016/07/07/a-beginners-guide-to-sql/

Free books - http://www.java67.com[..]inners-and-experienced-pdf-download.html


(google search) (amazon search)
second
download zip of files only