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?  (Russell Smith <mr-russ@pws.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Guy Rouillier
Дата:
Сообщение: Re: Upgrading side by side in Gentoo
Следующее
От: "hendra kusuma"
Дата:
Сообщение: Stored function - send array as parameter to stored function