Paragon Papers and ArticlesFeatures the latest programming and technology related articles from Paragon CorporationSQL Cheat Sheet: Query By Example- July 2, 2005 In this sql cheatsheet we will provide some common query questions asked and SQL solutions to these questions. Most of these examples are fairly standard ANSI-SQL so should work on most relational databases such as PostGreSQL, MySQL, Microsoft SQL Server, Oracle, Microsoft Access. Some examples involving subselects or complex joins may not work in most versions of MySQL and some versions of Microsoft Accesshttp://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=27 |