SQL Select Distinct Values | Dataford Interview Questions

How would you select distinct values from a column in SQL?

Use the wix_site_templates table and its template_category column. Return every unique category, including one row for NULL when present.

Output

wix_site_templates

Column	Type	Description
template_idPK	INT	Unique identifier for the site template
template_category	VARCHAR(50)	Category assigned to the site template

Your question is SQL Select Distinct Values. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

How would you select distinct values from a column in SQL?

Use the wix_site_templates table and its template_category column. Return every unique category, including one row for NULL when present.

wix_site_templates

Column	Type	Description
template_idPK	INT	Unique identifier for the site template
template_category	VARCHAR(50)	Category assigned to the site template

Your question is SQL Select Distinct Values. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.