Posts from the ‘SQL’ Category
- Truncated Mean in Oracle on April 6, 2010
- SQL Injection License Plate on March 23, 2010
- A good entry-level interview question on March 17, 2010
- How to Change the ORDER BY When You Can’t Modify the SQL on December 23, 2009
- Two questions about stored outlines on August 29, 2009
- Create Excel file from SQL query using Python on July 25, 2009
- Great number formatting trick on July 24, 2009
- A good reason to change NVL to COALESCE on June 5, 2009
- Prefix searches, Wildcard characters and LIKE on July 14, 2008
- WITH With an IN; or, A Reason to Refactor on May 2, 2008
