SQL | KILLING STEPS TO INTRODUCE SQL DATABASES: Knowing SQL Can Help You Improve Your Skills As A Developer by Brumm Ben

Author:Brumm, Ben [Brumm, Ben]
Language: eng
Format: epub
Published: 2020-04-25T16:00:00+00:00

The WHERE clause allows you to filter out records that don’t meet the criteria you specify. It only shows records that match.

So, if we want to see only customers that have a credit limit of over 1000, our query would include this line:

WHERE credit_limit > 1000

Any records that meet these criteria are shown.

We need to combine this with our SELECT query to complete the query.

SELECT id, first_name, last_name, credit_limit, registered_date, country

FROM customer

WHERE credit_limit > 1000;

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.