1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| select
(case
when form_8.re_type_form(o.id)=1 then 'земля'
when form_8.re_type_form(o.id)=4 then 'лес'
when form_8.re_type_form(o.id)=5 then 'пик'
when form_8.re_type_form(o.id)=29 then 'линейное'
when form_8.re_type_form(o.id)=99 then 'иное'
when form_8.re_type_form(o.id)=231 then 'нежил'
when form_8.re_type_form(o.id)=232 then 'жилое'
end)"ТипОбъекта"
,count(id)"КолОбъект"
from
re_objects o
where
O.ID in (select r.re_id from rt_rights r)
group by (case
when form_8.re_type_form(o.id)=1 then 'земля'
when form_8.re_type_form(o.id)=4 then 'лес'
when form_8.re_type_form(o.id)=5 then 'пик'
when form_8.re_type_form(o.id)=29 then 'линейное'
when form_8.re_type_form(o.id)=99 then 'иное'
when form_8.re_type_form(o.id)=231 then 'нежил'
when form_8.re_type_form(o.id)=232 then 'жилое'
end)
|
Комментариев нет:
Отправить комментарий