Select Page

Category: SQL

Views You Can Use: Ordinal Numbers

Cardinals and Ordinals As a child, I learned about cardinal and ordinal numbers. I just checked Wikipedia and found that my understanding of them is … childlike. I remember cardinal numbers as non-negative integers; 0, 1, 2, 3,...

Read More

Little Known SQL Syntax

We may be designers and programmers, but we often need to look at the contents of the database to help our customers deal with problems.  I probably spend as much time writing SQL select statements in Quest Software’s TOAD...

Read More

Bad SQL Redesigned

The Assignment Last week we looked at various techniques for combining tables.  As an example, we took an assignment “to gather the hours reported on timecards for each employee over a two week pay period.”  We saw...

Read More