SQL - Part 7 - Where Clause

[@QAFox]

For any doubts, live training updates and free Courses please join our Telegram channel t.me/qafoxoriginal

[@vaibhavpatharkar6794]

When u said to use single quotes for where clause. We understand how deeply you teach. Salute for that JAI SHREE RAAAM 🚩

[@QAFox]

Thank you :)

[@mdarif8954]

Hi, when I am searching the data with postal code 05023 or 5022, its showing result only when it is put in single quotes, without single quotes its not working, why is it so, is there anyone else who is facing the same issue, please let me know

[@melvagijo8456]

Your video lectures are very easy to understand. You are an amazing teacher!! Thank you so much.

[@QAFox]

You're very welcome!

[@mdarif8954]

Hi, when I am searching the data with postal code 05023 or 5022, its showing result only when it is put in single quotes, without single quotes its not working, why is it so, is there anyone else who is facing the same issue, please let me know

[@pawankumard7929]

Very Good Sir .This will be very useful in future too....for many...

[@QAFox]

Thank you :)

[@mdarif8954]

Hi, when I am searching the data with postal code 05023 or 5022, its showing result only when it is put in single quotes, without single quotes its not working, why is it so, is there anyone else who is facing the same issue, please let me know

[@yashwanthsain3855]

thanks for your video lectures sir really helpful for beginners like us

[@QAFox]

Welcome Yashwanth :)

[@swarajpawar5092]

Sir you teach nice and heartily i appreciate your teaching ❤but when I apply condition on w3 school it's show no results plz help me to regarding this problem

[@QAFox]

Can you provide more details of your problem.

[@swarajpawar5092]

@@QAFox when I run command select*from customer where 'germany' it doesn't work the result show no results

[@desireddysaicharan5615]

@@swarajpawar5092 It is because you are using small case g, once try with capital G , bcz the text provided in quotes is case sensitive I think(not sure)

[@desireddysaicharan5615]

@QAFox Sir plz confirm

[@mdarif8954]

Hi, when I am searching the data with postal code 05023 or 5022, its showing result only when it is put in single quotes, without single quotes its not working, why is it so, is there anyone else who is facing the same issue, please let me know

[@subhamkumarsah933]

Very nicely explained

[@QAFox]

Thank you :)

[@mdarif8954]

Hi, when I am searching the data with postal code 05023 or 5022, its showing result only when it is put in single quotes, without single quotes its not working, why is it so, is there anyone else who is facing the same issue, please let me know

[@hariharansuchindran2216]

Me too facing the same issue.

[@kuppuravurijyothipriyanka9781]

what happens if i entered any unlisted country or city

[@mahalakshminaik1961]

How many times where clause can be used in select

[@tabrejsiddiqui1656]

Only 1 time

[@shubhamdeshpande4712]

Helping alot sir❤️

[@QAFox]

Welcome :)

[@amruthasankar3453]

Thankyou sir🤩🤩🤩🤩

[@QAFox]

Welcome :)

[@luckyymax]

Well explained sir

[@QAFox]

Thank you :)

[@munirajub7818]

Hi sir can you please share me a slide

[@QAFox]

I am not using any slides. You can find notes in the description of this video.

[@Nosupportsa]

Good one 👍

[@shre0105nt]

Great Explanation

[@QAFox]

Thank you Shreya :)

[@mohammadhayatmohammadi5306]

Dear Sir! SQL is case-sensitive. I checked it,

[@saqlainansari589]

It's not case sensitive you use capital words and small words aswell ..

[@Lucifer._.658]

Sir no result likh ke aa raha hai

[@abhihonrao4488]

THANKS MAN😊😊😊

[@QAFox]

Welcome :)

[@partabparmar5537]

thank you sir

[@QAFox]

Most Welcome :)

[@yashuy3279]

Thank You Sir.

[@QAFox]

You are most welcome

[@sarthak9103]

In this lecture video and audio didn't match you're writing something else and explaining something else there's a gap between audio and video

[@QAFox]

Okay, I will check this video.

[@tarungandreddi3045]

Select CustomerName,Country,City where City='London'; this isn't working

[@nitwin9075]

Select CustomerName,Country,City from customers where City='London';

[@manasakb9382]

did you get it ? am also facing the same problem

[@peaceofmind3124]

You need to mention table/file name, from where you want to get data. So you must need to me mention (Select customername, country, city from customers where city='London').

[@badboylucky5729]

no results i found

[@badboylucky5729]

in this case

[@pavangsk8404]

wonderful

[@QAFox]

Thank you! Cheers!

[@mahalakshminaik1961]

How many times where clause can be used in select statements

[@th3graduate292]

Thank you sir.

[@QAFox]

Welcome :)