Tip Bank

DevX

Calculating Averages Within Arbitrary Groups

Question: [Joe Celko’s Production Report Puzzle]We get a production report from work centers which has a date, center code and how many widgets were produced from each batch of raw

DevX

Finding the Top n Within a Group

Question: [Joe Celko’s Best Salesmen by Territory Puzzle]Martin Tillinger posted this problem on the MSAccess forum of CompuServe. How do you get the top three salesmen in each territory, given

DevX

What is VRML?

Question: I’ve heard a lot about VRML, but don’t know what it is. Please explain. Answer: VRML (Virtual Reality Markup Language) is a method for sending 3D data across the

DevX

ODBC Versus SQL

Question: What are the disadvantages of ODBC versus SQL? Answer: ODBC is a generic implementation, whereas native SQL is always optimized for the database server being used. Thus, if you