How do you select specific columns and filter rows?

SQL SELECT, filtering and sorting · Freshers

Model answer

SELECT name, price FROM products WHERE price > 100; Select only the columns you need instead of SELECT *, which is slower and fragile when the schema changes.

Learn this topic

SELECT, FROM and WHERE: Your First Queries in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions