Tuesday 16 August 2016

CASE Example in POSTGRES

SELECT  
CASE WHEN "EQU000"."city_C"= 'abc'
THEN 'cityNAME'
ELSE 'Group'
END AS "NAME"
FROM "EQU000" 

COURTS : CASES : LAWYERS : JUDGES : ::::::::: VICTIMS : ACCUSED

  *We have got so many SMART people in our COUNTRY. *we have got so many IIT completed SMART students in our COUNTRY. * we have got so many ...