Skip to Content
Menu
This question has been flagged
1 Atsakyti
2420 Rodiniai

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 ?

Portretas
Atmesti
Best Answer

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

Hope it helps

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
2
liep. 24
1707
1
birž. 24
4276
2
kov. 24
8324
3
vas. 24
5437
1
vas. 24
1383