Board index » delphi » Group by syntax

srs1...@hotmail.com (Dave Williams)

Delphi Developer
Sun, 21 Mar 2004 21:43:40 GMT

Group by syntax

 Greetings folks,

  we are trying to write a simple statement

  Select
     Cast(column1 as varchar(32)) Name, count(column2)
  from
    sometable
  group by  Name

Gives the column unkown error , so does group by 1

I know other RDBMS allow grouping of aliased columns, any comments would be
appreciated.

DW

 
Sergio Samayo

Delphi Developer
Sun, 21 Mar 2004 22:01:47 GMT

Re:Group by syntax


Try: group by 1

--
Sergio Samayoa
Lgica Software
http://www.geocities.com/logicasw/

Dave Willia

Delphi Developer
Sun, 21 Mar 2004 22:33:40 GMT

Re:Group by syntax


uknown Column 1 ????????
Quote
In article <3bbb1951_2@dnews>, "Sergio Samayoa" <serg...@terra.com.gt> wrote:
>Try: group by 1

Team

Delphi Developer
Sun, 21 Mar 2004 22:43:26 GMT

Re:Group by syntax


Quote
Dave Williams wrote:

> I know other RDBMS allow grouping of aliased columns, any comments would be
> appreciated.

        Put the SELECT in a VIEW, and group the fields in the VIEW.

        -Craig

--
 Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
We're hiring: http://www.vertexsoftware.com/careerops.htm#sd
     Delphi/InterBase WebLog: http://delphi.weblogs.com

Ivan Prenosi

Delphi Developer
Mon, 22 Mar 2004 00:26:12 GMT

Re:Group by syntax


Quote
>   we are trying to write a simple statement

>   Select
>      Cast(column1 as varchar(32)) Name, count(column2)
>   from
>     sometable
>   group by  Name

What is the purpose of the CAST in your statement ?

Ivan

Other Threads

1. SQL syntax using SUM and GROUP BY

2. SQL query syntax using SUM and GROUP BY

3. Win95 Program Group within a Group

4. Meeting: Delphi Users Group (SIG of Capital PC User Group)

5. 2 groups in 1 Group?

6. Fax group 4 and group 3 compression

7. not a single-group group function

8. Group by not grouping by

9. Getting data of next group in group foother

10. qr grouping and not displaying data for a group