harsha547
4/2/2017 - 4:17 PM

CHOOSE and ELT Function in SQL SERVER and MySQL

CHOOSE and ELT Function in SQL SERVER and MySQL

-- CHOOSE Function For SQL SERVER Version

SELECT CHOOSE(3,'Harsha','Gambhir','Vardhan','Yuvraj') AS Name;

-- ELT Function for MySQL Version
-- Try Below Function in MySQL

SELECT ELT(3,'Harsha','Gambhir','Vardhan','Yuvraj') AS Name

-- Linkedin Profile : https://www.linkedin.com/in/harshasannareddy/