can someone help me to make a sql more pretty and more concise?
От | Yi Zhao |
---|---|
Тема | can someone help me to make a sql more pretty and more concise? |
Дата | |
Msg-id | 1226539286.3855.12.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Upgrading side by side in Gentoo (Guy Rouillier <guyr-ml1@burntmail.com>) |
Ответы |
Re: can someone help me to make a sql more pretty and more
concise?
|
Список | pgsql-general |
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' !!!!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 по дате отправления: