Re: can someone help me to make a sql more pretty and more concise?

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?
> >
> >
> >
>
>