Geeks With Blogs
Jim Lahman's Blog Fortitude|Endurance|Faith|Teamwork August 2010 Entries
Selecting unique values from an Oracle table
There are times when we only want to the unique records from a table where there are many records that have the same value. In this example, I have a table that stores all the coating weight footage measurements for a strip of steel as it moves thru the zinc pot. The primary key of this table is composed of the four columns: Column Type WTAG NUMBER(7,0) MULT_NUM NUMBER(2,0) CUT_NUM NUMBER(3,0) FT_CWG NUMBER(6,0) so, as one can see, from the primary key definition, a single coil, as identified by ......

Posted On Wednesday, August 4, 2010 2:48 PM

Copyright © Jim Lahman | Powered by: GeeksWithBlogs.net | Join free