Re: URGENT : Query for Aggregate functions

From: Thava Arumugam <tarumuga_at_online.no>
Date: Wed, 30 Jun 1999 14:13:40 +0200
Message-ID: <8Sne3.183$Gx.962@news1.online.no>

One line expression is like
select column_name * 1.5,column_name1 - column_name2 from <table>

aggreate function is like
select column_name1,max(column_name2),sum(column_name3) from <table>
group by column_name1

Yes, you can use them together and then you have to group by function.

Brgds
Thava

Sekhons <anoops_at_sympatico.ca> wrote in message news:gZWd3.23610$5a.29532_at_news20.bellglobal.com...
> Hi,
>
> Could anyone tell me what is the difference between aggregate functions
and
> one line expressions and whether we can use them together. And if we can
> then do we have to use a ".
> group-by-function".
>
> It would be of great help if someone could please reply to me soon.
>
> Thanks.
>
> Sherry
>
>
Received on Wed Jun 30 1999 - 07:13:40 CDT