Snipplr

(SQL) Update table with values selected in a subquery - preasha

Mon, 29 Aug 2011 22:34:04 GMT

The inner join could be nested too

(SQL) users with more than one of a gateway - lastobelus

Thu, 24 Mar 2011 07:20:25 GMT

(MySQL) calculate the difference between dates in one columns within the same table - bradless

Fri, 19 Feb 2010 12:06:53 GMT

I use something similar to the example to get the difference between statuses in a status log table that I have. It comes in handy when determining the number of days between status changes. This works in MySQL 5.0.

(SQL) Find all categories NOT used in current item - stavelin

Sun, 21 Sep 2008 16:03:24 GMT

It's easy to find the categories used on one item, but find all categories NOT used on current item? This snippet stores a "NOT IN" query. This is used with PHP & mySQL. The query can be written differently on other databases, but this seems to work with mySQL.

(PL/SQL) Efficiently compare results from two queries - stews

Wed, 17 Sep 2008 17:33:02 GMT

This compares selected columns between 2 queries, using the WITH clause. It lists the rows and values that are different between the two sources. This is from Tom Kyte (www.asktom.com). I can't say I understand exactly how it works, but it's much faster than other methods I've seen, because it only looks through each query once.

(SQL) TSQL to Concatenate Subquery Row Values into a Column Value - rengber

Wed, 19 Mar 2008 22:54:33 GMT