devxlogo

March 25, 1997

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

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

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

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

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

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

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