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? > > > > > > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
