İçereği Atla
Menü
Bu soru işaretlendi
1 Cevapla
2513 Görünümler

select req,
SUM(case when (stage='Selected') then count else NULL end) as Selected,
SUM(case when (stage='Initial Selection') then count else NULL end) as "Initial Selection",
SUM(case when (stage='Hr Round') then count else NULL end) as "Hr Round"
from table1 Group by req

In the above psql query stage is passed statically(hard coded) in CASE statement , How can we pass stage name dynamically from stage_table ?

Avatar
Vazgeç
En İyi Yanıt

Hi, you can follow this: https://youtu.be/ntMaAYbsDYM 

Hope it helps

Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
2
Tem 24
1949
1
Haz 24
4486
2
Mar 24
8444
3
Şub 24
5551
1
Şub 24
1468