SQL Server query using CHOOSE function to select the third value from a list, returning '.NET' as the selected result in the output.

This image demonstrates a SQL Server query that utilizes the CHOOSE function. The query selects the third item from a list of values ‘PHP’, ‘SQL’, and ‘.NET’, resulting in the output ‘.NET’ under the column labeled “New SQL Server Release”. This example highlights how the CHOOSE() function simplifies value selection based on position in SQL queries.

×

Table Of Content