Articles & Content


Common SQL Questions: Why and How-to (L04)

Topic: Informix

Subtopic: 2006

DATE: 2006-5-9 (08:30 AM - 09:40 AM)
SPEAKERS: June Hunt (Tyler Technologies Inc., MUNIS Division)

There are a few questions that come up time and time again. Why do certain SQL statements behave the way they do, and how do I get a particular set of results? This presentation will cover some of the most frequently asked SQL-related questions. We'll also discuss how to find out how others have found answers and solutions to similar problems.

EXP. LEVEL: Beginner,Intermediate


DATE and DATETIME calculations and comparisons

Using CURRENT in stored procedures

COUNT, ORDER BY, and other special conditions

Explain plan query estimates

Replace newlines in text

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.