Hi everyone,
I'm creating a view off of an existing table. My table has 3 columns: item,
location, and subordinate item. One item at one location can have multiple
subordinate items. In creating my view, I want to select only the first
instance that I come across i.e. I want to exclude more than one row with
the same values for item and location. I really want to keep the value of
the first subordinate item intact, so I don't want to select item, location,
min(subordinate) group by item, location. Besides, subordinate item is of
type CHAR. Any suggestions?
Received on Thu Jan 18 1996 - 17:05:30 CST
