refer to computed columns

Поиск
Список
Период
Сортировка
От Bruno Mueller
Тема refer to computed columns
Дата
Msg-id cgflp3$k7a$1@news.hub.org
обсуждение исходный текст
Список pgsql-sql
Hi

Think of the following query:

1 select
2  country,
3  (select sum(salary) from employees) as totalSalary,
4  sum(salary) as countrySalary,
5  countrySalary / totalSalary as countryPct
6 from employees
7 group by country
8 order by country
;

I know it does not work, but is there a way to refer to
the "computed" columns in line 5, so that I do not have
to repeat the calculations again.

BTW, are the calculation done more then once if I specify

1 select
2  country,
3  (select sum(salary) from employees) as totalSalary,
4  sum(salary) as countrySalary,
5  sum(salary) / (select sum(salary) from employees) as countryPct
6 from employees
7 group by country
8 order by country
;

Thanks for the help

Bruno



В списке pgsql-sql по дате отправления:

Предыдущее
От: Sascha Ziemann
Дата:
Сообщение: CREATE TYPE VARCHAR2
Следующее
От: "David Price"
Дата:
Сообщение: Optimizer Selecting Incorrect Index