Articles → SQL SERVER → Choose Function In The SQL Server

Choose Function In The SQL Server






Purpose





Example


SELECT CHOOSE(0, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry') 
Union
SELECT CHOOSE(1, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry') 
Union
SELECT CHOOSE(2, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry') 
Union
SELECT CHOOSE(3, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry') 
Union
SELECT CHOOSE(4, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry') 
Union
SELECT CHOOSE(5, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry')



Output


Picture showing the output of choose function in sql server
Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Friday, May 12, 2023

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250