Sat Sep 14 13:01:40 GMT 2024

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/

10 Quick SQL Tips After Writing Daily in SQL for 3 Years - https://towardsdatascience.com[..]ng-daily-in-sql-for-3-years-37bdba0637d0

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

9 SQL tricks you may not know about - https://meganlieu.substack.com[..]om/p/9-sql-tricks-you-may-not-know-about


(google search) (amazon search)
1 2 3 second