Re: can someone help me to make a sql more pretty and more concise? - Mailing list pgsql-general

From Yi Zhao
Subject Re: can someone help me to make a sql more pretty and more concise?
Date
Msg-id 1226569492.3855.26.camel@localhost.localdomain
Whole thread Raw
In response to Re: can someone help me to make a sql more pretty and more concise?  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-general
thanks for ur help,
but, I think that is not my want:D
if you use sum like this, it must be with group by,
what I want is do sum on all columns, not group by.

thanks

regards,

在 2008-11-13四的 19:27 +1100,Russell Smith写道:
> Yi Zhao wrote:
> > I want to select some column(a, b) from the table with the specified
> > condition, so, i can do like this:
> > select a, b from mytable where id = (select id from temptable where
> > tname = 'df' ) and stype = 'def' and range = 'afk'
> >
> How about;
>
> SELECT a, b, count(1), sum(c) FROM mytable WHERE id = (select id from
> temptable where
> tname = 'df' ) and stype = 'def' and range = 'afk' GROUP BY 1,2;
>
> Russell.
> > !!!!but, I want the result contains a sum(c) and a count value extra,
> > so, I use the sql below:
> > select a, b,
> >     (select count(1) from mytable where id =
> >       (
> >         select id from temptable where tname = 'df'
> >       ) and stype = 'def' and range = 'afk'
> >     ),
> >     (select sum(c) from mytable where id =
> >       (
> >         select id from temptable where tname = 'df'
> >       ) and stype = 'def' and range = 'afk'
> >     )
> >   from mytable where id = (
> >     select id from temptable where tname = 'df'
> >   ) and stype = 'def' and range = 'afk';
> >
> > can someone help me to make this sql statement above more pretty and more concise?
> >
> >
> >
>
>


pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Suboptimal execution plan for simple query
Next
From: "Andrus"
Date:
Subject: Re: Upgrading side by side in Gentoo