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 по дате отправления: