SQL Playground
TutorialsPlayground
SQL FormatterSQL MinifierSyntax ValidatorJSON to SQLCSV to SQLSQL to JSONER Diagram Generator
Daily ChallengeInterviewsCheat SheetBlog

© 2026 SQL Playground. Built for developers.

PrivacyTermsAboutRSS Feed
SQL Playground
TutorialsPlayground
SQL FormatterSQL MinifierSyntax ValidatorJSON to SQLCSV to SQLSQL to JSONER Diagram Generator
Daily ChallengeInterviewsCheat SheetBlog
Initializing...
Chapter 1: The SELECT Statement
1-2
Your Progress

Selecting Specific Columns

Often, you don't need every column in a table. You can specify exactly which columns you want to retrieve.

SELECT name, email FROM users;

This is better for performance and readability.

Task: Modify the query to select only the name and role of all users.

Loading...
Run a query to see results