Re: can someone help me to make a sql more pretty and more concise?
От | Yi Zhao |
---|---|
Тема | Re: can someone help me to make a sql more pretty and more concise? |
Дата | |
Msg-id | 1226569492.3855.26.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: can someone help me to make a sql more pretty and more concise? (Russell Smith <mr-russ@pws.com.au>) |
Список | 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 по дате отправления: