MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2013

Re: still dont' get how to group by



fixed

Hi

Others have answered your question.

I have an idea, for better understanding of SQL - take the tutorial at w3schools.com - they have really excellent stuff, and this tutorial will _almost_ all apply to IBM i SQL, as well as almost any other RDBMS, such as MySQL or SQL Server or whatever.

Note the "almost" - there are functions in the tutorial that we don't have on IBM i - we have something that will get the same thing, usually - examples are things like FIRST() and LAST().

There's also a nice menu for all kinds of things, including "SQL GROUP BY" - this is useful when looking for something specific.

The link is at http://www.w3schools.com/sql

I heartily recommend this or some other tutorial. There's everything in the SQL Reference for DB2 on IBM i, but it's not always easy to find one's way into it.

HTH
Vern

On 12/31/2013 9:03 AM, Hoteltravelfundotcom wrote:
Why does this group by not work, what is it I need to do?

Column NAME or expression in SELECT list not valid.
CREATE VIEW PROJ_CRWN1/DATA_WHSV2 AS SELECT CUSTOMER#, NAME, STATE,
ITEM#, PROD_LINE, INVOICE#, ORD_DATE, INV_DATE, ORD_TYPE,
CUST_TYPE, QUANTITY, EXTENDED$ FROM Proj_Crwn1.DTAWHS
GROUP BY CUSTOMERr#






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact