How to Filter with the WHERE clause in SQL
HTML-код
- Опубликовано: 16 окт 2024
- Filter your SQL table for the information you need by using the WHERE clause!
Queries using WHERE:
1) Filter your query based on an exact match: SELECT * FROM table WHERE column='value'
2) Filter your query using Wildcards to match a pattern: SELECT * FROM table WHERE column LIKE '%str%ing%'
3) Filter your query using numeric operators: SELECT * FROM table WHERE column < 5
4) Beef up your filters by using the AND & OR statements: SELECT * FROM table WHERE (column1 < 5 AND column2 LIKE '%a%') OR column3 = 1
5) Exlude info from you query using the NOT clause: SELECT * FROM table WHERE NOT column1 = 1
6) Pull a range of information using the BETWEEN clause: SELECT * FROM table WHERE column1 BETWEEN 1 AND 5
7) Extract all the NULL or NOT NULL values out of your table: SELECT * FROM table WHERE column1 IS NULL
Get the Northwind Database: • How to Load a Sample P...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:
So glad I found this. This is so direct and clear. Thank you!
Badly he dont have a lot of videos did u find other good course for sql server?
Very Important topics SQL for data science learn
Tell me
Just subscribed thank you for all your information you break it down so well
You’re amazingly awesome. Love the way you teach SQL. You make everything simplest possible.
Badly he dont have a lot of videos did u find other good course for sql server?
Thank you so much for the clear explanation.
you are helping so many people , thank you!
I just want to say thank you so much for this
Thank you so much for your video! they are easy and you get straight to the point :)
you're amazing one video is enough for WHERE clause
Thank you so much for your help. I was struggling with the WHERE statement (filter data by listing all managers). In my case it was listing all movies released in January, February etc. Thanks again God Bless 😇👍
Thank you! This playlist is very helpful.
This was beyond helpful thank you so mcuh!!!
Great video, please keep making more. they are very helpful!
Badly he dont have a lot of videos did u find other good course for sql server?
your videos are just perfect ❤
I like your videos and I think they are a good choice for those who have the basic idea. Have you considered giving some practices at the end of the video or a video full or practices with the answer?
Badly he dont have a lot of videos did u find other good course for sql server?
Its really great and underrate video, thanks alot
So helpful, thank you.
Hi
What will happen if we have a select query with multiple conditions in where clause (mix of equal to, not equal to, between, greater than, less than) with and/or without parentheses?
Will it fetch correct results?
Please let me know.
Thank you!
Your vedeo is helpful
Thank you. Really helpful!
Very helpful! Thank you!
percent sign is called a modulo
Appreciate your work
For example country column is holding some country names like USA, UK, India, Australia and some Null values, In my case I need to filter country name 'USA' and fields which is 'NULL' in single where condition. Does there is any other way to filter these condition. Pls let me know answer to this question. Note: Null is not a value in that country column.
Thank you brother, this is so helpfull
Thank you very much! Happy to hear it helped ya out!
ruclips.net/video/i2BjvSNJprA/видео.html
Hello,could i get help on how to join 5 tables please.David
thank you
1 MILLION TIMES BETTERTHEN MY TEACHER AT SCHOOL