March 25, 1997

DevX - Software Development Resource

Finding Data Based on Contents of Multiple Columns

Question: Joe Celko’s Playing the Ponies Puzzle]You have just become the database manager for Eddie Franco “the Doctor” Coddetti. He keeps records on horse races for statistical purposes and his

DevX - Software Development Resource

What is GMD’s Dynamic Worlds proposal about?

Question: Please explain Dynamic Worlds. Answer: “The Power of Dynamic Worlds” proposal from the German National Research Center (GMD) is based on an interaction model developed for collaborative distributed virtual

DevX - Software Development Resource

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 - Software Development Resource

INSERT INTO Syntax

Question: What is the standard SQL-92 syntax for INSERT INTO? Answer: Be sure to check your product documentation for any variations! This is standard syntax, but not all products will

DevX - Software Development Resource

Tax Problem Puzzle

Question: [Joe Celko’s Tax Problem Puzzle]I got this one from Richard S. Romley, via CompuServe. We were engaged in a debate about Sybase’s old T-SQL versus ANSI/ISO SQL-92. I assume

DevX - Software Development Resource

How can I create VRML pages?

Question: What can I use to produce VRML, or can I write it like HTML? Answer: It is possible to write VRML as a purely text-based language, using a regular

DevX - Software Development Resource

How compatible are VRML browsers?

Question: If I make a VRML page, can it be read by any browser? Answer: The original idea behind VRML 1.0 was that any VRML scene should be viewable using