🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task

Root categories list

SQL Server 2022
Get the list of root categories from the ProductCategory table.
Output the result in one column ProductRootCategories sorted alphabetically.
Expected result Columns: 1 · Rows: 4
ProductRootCategories

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query