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



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

Query/Feedback


Your Email Id
 
Subject
 
Query/FeedbackCharacters remaining 250