Sometimes a program requires that the results of a query be returned in a specific sequence. We all know that the ORDER BY clause can be used to sort SQL results into a specific order. But what if we need to sort it by total compensation?
Read this article..
Craig S. Mullins is a data management strategist, researcher and consultant. He is president and principal consultant of Mullins Consulting, Inc., and has nearly three decades of experience in all facets of database systems development.
Craig has worked with mainframe DB2 since V1 and has experience with several other DBMS products, including SQL Server, Sybase and IMS. You may know Craig from his popular books: DB2 Developer's Guide
, which has more than 1,500 pages of in-depth technical information on DB2 for z/OS, and Database Administration: The Complete Guide to Practices and Procedures
- the industry's only comprehensive guide to heterogeneous database administration.
More information on Craig is available at www.craigsmullins.com
comments powered by