Skip to main content

SkillsFree Assessments My progress

Home
Skills
SQL for Data Analysis (Beginner)
Sorting, Limiting, and Distinct Results
Practice

Chapter 5 of 13Chapter overview

Set 2: Core PracticeActivity 1 of 3 in this set

Free practice · single-choice · easy

Practice

Use DISTINCT deliberately

A table has many customers per state. Which SELECT returns one row per state_code value?

Choose one answer

SELECT DISTINCT state_code FROM customersSELECT state_code FROM customers LIMIT 1SELECT state_code FROM customers ORDER BY state_code

Free, practical skill-building for everyone—no account or subscription required.

Start free practice →

Learn

Free skills
Assessments
My progress

Your data

Backup & restore
Settings
Privacy

Platform

About
Contact
Editorial standards
Terms
Disclaimer

Follow SocialMediaSir

Official profile on every channel: SocialMediaSir

100% free educational practice. Progress stays on this device.