Re: How to get first record of each item only ?

SELECT itemid, MIN(qty) from table;

Before you complain "that doesn't work!" , Please define which one is the "first item"

This is a Relational Database we are discussing. There is no ORDER to the rows in a table.

 There may be order in the result set only when you apply one (SELECT ... ORDER BY ...). Received on Thu Apr 21 2005 - 12:50:59 CDT