Sat Sep 14 13:01:40 GMT 2024 From /weblog/database/sql

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)

Mon Jun 17 00:30:14 GMT 2019 From /weblog/database/sql

join

http://www.codeproject.com[..]33052/Visual-Representation-of-SQL-Joins http://nosql.mypopescu.com/post/51770099382/sql-joins-visualized

With IN and subquery / or "top" like keywords - http://javarevisited.blogspot.com.au[..]econd-highest-or-maximum-salary-sql.html

Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot
- https://dev.to[..]-database-for-beginners-best-of-lot-5533

(google search) (amazon search)

Fri Jan 22 03:39:27 GMT 2016 From /weblog/database/sql

grouping

There is way to drop the dummy aggregate function in group by - http://blog.jooq.org[..]onal-dependencies-a-very-useful-feature/

(google search) (amazon search)

Mon Jan 13 04:24:11 GMT 2014 From /weblog/database/sql

Problem of SQL

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

http://www.oreillynet.com/lpt/a/6060

How to simulate column reuse, which is missing from standard SQL - http://blog.jooq.org[..]/the-sql-languages-most-missing-feature/

(google search) (amazon search)

Fri Apr 29 06:41:53 GMT 2011 From /weblog/database/sql

time

Function that convert string to timestamp for mssql, oracle and sybase - http://connectsql.blogspot.com[..]ql-server-basics-todate-function-in.html

(google search) (amazon search)

Tue Jan 11 00:46:00 GMT 2011 From /weblog/database/sql

xml

manipulate xml in sql server - http://www.15seconds.com/issue/050803.htm

(google search) (amazon search)

Sat Mar 21 10:54:47 GMT 2009 From /weblog/database/sql

except

example of except keyword - http://sqlblog.com[..]rence-between-two-sets-of-like-data.aspx

(google search) (amazon search)

Mon Oct 15 11:32:55 GMT 2007 From /weblog/database/sql

ansi joining

A nice article about standard ANSI joining syntax:

http://www.oracle.com/technology/oramag/oracle/01-nov/o61sql.html

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.

http://www.onjava.com/lpt/a/4443

A blog with nice graphic show how join work - http://www.codinghorror.com/blog/archives/000976.html

(google search) (amazon search)

Wed Jun 13 15:34:34 GMT 2007 From /weblog/database/sql

solve sudoku in sql

A very complicate TSQL sample... in my opinions: http://www.vsj.co.uk/articles/display.asp?id=540

Even more implementation - http://lambda-the-ultimate.org/node/2291

which introduce some interesting function in vendor specific SQL, like Oracle MODEL - http://download-uk.oracle.com[..]erver.102/b14223/sqlmodel.htm#sthref1855

(google search) (amazon search)