Tip Bank

Question: How do I find the top n records within a table for version 7? I have seen some similar SQL queries but cannot adapt them to version 7. Answer:

Question: Does it make a difference in placing an OUTER or simply a JOIN or a WHERE? Using WHERE: select tb01_field01,tbl01_field02 from tb01,tb02 where tb01_field01 = tb02_field01 Using JOIN: SELECT

Question: In Access, I can get the date that was this day of this week a year ago (i.e., if today is Monday, 5/15/00, a year ago was Monday, 5/17/99)

Question: Does Informix have a function that converts datetime chars for numbers? Answer: Datetime is stored internally as an integer that represents the number of seconds from a certain starting

In the olden days, the use of floating point numbers imposed a significant computation and speed overhead compared to integer arithmetic. For this reason, many optimization guidebooks and IT veterans

A CPU cycle is roughly equivalent to the time needed for performing one instruction. On modern CPUs, a cycle takes about a nanosecond. In other words, a Pentium III 900

Although the Standard Library doesn’t define functions that convert Fahrenheit degrees to Celsius degrees and vice versa, you can implement them by yourself. These functions are particularly useful in localization

Some applications have special memory requirements. For example, they allocate large amounts of memory at once and then use it in parts, or they allocate only objects of the same

Many believe that a byte is by definition, an eight-bit data unit. Technically, this definition isn’t correct. A byte is a data unit with an unspecified number of bits. Indeed,