Retrieve Data Using Query | SQL Commands | Class 10 Database Management System

Retrieve Data Using Query | SQL Commands | Class 10 Database Management System
Join this channel to get access to perks:
/ @swatichawlaofficial
Click on this link to visit the online store to buy the customised products.
/ @swatichawlaofficial
To download the study material issued by CBSE, click on the following link:
Employability Skills
cbseacademic.nic.in/web_materi...
Subject Specific Skills
cbseacademic.nic.in/web_materi...
Part - A ( Employability Skills)
Unit - 1 Communication Skills - II )
Introduction, Communication Cycle, Types of Communication
• Unit - 1 Communication...
Feedback in Communication and 7 C's of Communication • Feedback in Communicat...
Communication Barrier and its types, Overcoming Communication Barrier
• Communication Barrier ...  
Part - B (Subject Specific Skills)
Install OpenOffice
• How to Download and In...
Unit - 1 (Digital Documentation - Advanced)
Create and Apply Styles in the Document
• Create and Apply Style...
Insert and use images in document
• Insert and use images ...
Create and use Template
• Create and use templat...
Create and Customize Table Of Contents
• Create and Customize T...
Implement Mail Merge
• Mail Merge in OpenOffi...
Unit - 2 (Electronic Spreadsheet - Advanced)
Consolidating Data and Calculating Subtotal in OpenOffice Calc
• Consolidating Data in ...
What - if Analysis Tools (Scenarios, Goal Seek and Solver)
• What If Analysis Tools...
Linking Data and Spreadsheet
• Linking Data and Sprea...
Share and Review a Spreadsheet
• Share and Review a Spr...
Create and Use Macros in Spreadsheet
• Create and Use Macros ...

[@SwatiChawlaofficial]

Select is a DML COMMAND By mistake spoken.. DDL.. Sorry for the inconvenience caused...

[@bornshotliz0188]

Ok ma'am

[@dharshinirsvd5040]

Ok mam and we should use only capital letters in query?

[@pritam5008]

@@dharshinirsvd5040 yes ma'am tell sab kuch capital mei likh de kya

[@dhruvdayal1907]

No Problem

[@onlystudy5046]

OK m3

[@drako4436]

People watching it for practical exam 😂😂

[@wonder_ff_gaming1828]

Here also 🙂

[@Gaming75645]

Kal hi hai

[@PFM_GAMEKO.]

Aaj hi hai exam

[@Maaaanya]

I swear brooo

[@Tanushka77147]

Kl hi h practical exam 😅

[@aryanmittal7832]

Ma'am you can't know how I am relieved and understood from this video. From morning, I have checked around 10-15 videos about SQL and for reference I am watching at evening. Thank u so much.

[@SwatiChawlaofficial]

Most Welcome..

[@Adan_khan....09]

Cant nhi dont

[@Vyno-wv2wu]

@arynamittal7832 tera skill issue hai bhai... dusro ke video ko mat bol... neuro doctor ke pass ja

[@Samye55]

When I used to study in online class of my school and teacher taught IT,I could not understand what she used to blabber,but now everything is crystal clear because of you dear teacher "MISS SWATI",may you live a long,prosperous and a happy life..... Tomorrow is my IT preboard,hoping for the best..... Thank you

[@SwatiChawlaofficial]

Thanku so much... 🙏🏻🙂

[@hb5014]

Finally I understood all concepts of this.... I m struggling from this from Last month's and my teacher didn't clear it And now it is crystal clear Tomorrow is my exam I will give my best 💙💙💙 Thanks a lot ma'am 💞💞💞😘😘😘

[@SwatiChawlaofficial]

Glad it was helpful... Thanku so much..

[@soumeshkumar7323]

Yes I loved the explanation

[@Bhavs.]

The first KZbin channel that comforts us in IT, Thank you🤍

[@SwatiChawlaofficial]

Thanks and Welcome

[@SAINX.]

Exactly 🔥🔥

[@Classic_Car_Empire]

@@SAINX. 😂 Pkda gya 😂

[@SAINX.]

@@Classic_Car_Empire 🤣🤣

[@prajwalgurnule2241]

6:25 mam select is a dml command

[@SwatiChawlaofficial]

Yes... It was by mistake.. Sorry for the inconvenience caused..

[@dhyeyvachhani7504]

thanks for helping , watching your video before 2 hours of examination thank you so muchhhhhhhhhh

[@yogyatabhatnagar8514]

Thank you so much ma'am! This video helped a lot! I was trying to execute the commands but I wasn't able to earlier. But now I am able to do it because of you! Thank you so much❤️🥰

[@SwatiChawlaofficial]

Glad it was helpful !!! Thanku so much Keep Watching

[@ishikabhaskar1746]

Thank you so much ma'am tomorrow will be my IT practical and it will help me a lot!! 😊😇

[@SwatiChawlaofficial]

Welcome

[@hetanshishirokha6805]

Best explanation of this chapter one can ever find !! Thank you mam 😊😊

[@SwatiChawlaofficial]

Thanks and Welcome

[@indrapratapsinghrajawat3109]

OMG Mam I've been trying to understand this SQL thing since last 2 months I have watched tonnes of videos and all of them were a shit-show But your video has helped me tremendously with DBMS concepts I hope you grow and become the no. 1 study channel on KZbin cause you're a deserving teacher

[@SwatiChawlaofficial]

Thanku so much.... 🙂

[@rajchoudhary4998]

Same ☺️.... thinking from morning I watched 10-12 videos but unable to understand....now i can rock in exam .. thankyou mam😍

[@divyanshshukla1949]

mam you are the best teacher for IT u covered line by line every topic crystal clear mam u are the best

[@SwatiChawlaofficial]

Thanku so much 🙏🏻🙏🏻

[@kouseiwithoutthekousei3438]

Thank you soo much ma'am, your video covered everything! Helped a lot

[@anushkagautam7082]

Ma'am when we are not able to find our table we can also go to view > Refresh Table. It can also Help. Thank You though Ma'am It was helpful and definitely be fruitful too. 😊😊

[@SwatiChawlaofficial]

Thanks and Welcome

[@sakshiarya4413]

Maam you are a great teacher Now all concepts are crystal clear😇

[@SwatiChawlaofficial]

Thanku so much

[@ansh995]

Really legit explanation. School mai toh kuch bhi samaj nhi aaya. pata nhi kya padhaya bass copy mai likhwa dete the aur thoda sa explain kar dete the aak baar bhi Computer pa nhi karaya na hi karka dikhaya taki samaj aa jay 🤬🤬 aak toh pata nhi ya computer lab bnaya kyo hai jab usma lejana hi nhi hai toh. Best explanation aab samaj mai aaya aab mai iss topic mai confuse nhi hu 😊😊 thanks mam a lot 😊😊

[@RadhewithRajput]

Thank you so much mam I am not having system at my home but because of you I can score good marks tomorrow is my exam . Your explanation is best of all

[@SwatiChawlaofficial]

Thanku

[@fungamer3059]

Ma'am in create table command you said that we cannot enter space in table name ... But I made the table like this with its name as "Sr Library" i.e by using double quotes

[@InfinityShortss]

Mam Excellent Explainatation with theory and Practical Easy to Understand ❤ Thanks Mam Helpful a Lot!!

[@SwatiChawlaofficial]

Most welcome 😊

[@anmol299]

Thanku mam for all ur supports I have literally watched all the videos of dbms and web application and I will make sure that I will give my best and score full marks tomorrow in my pre board.

[@SwatiChawlaofficial]

Thanks and Welcome

[@anjanbhattacharya1061]

i don't think you have to close the entire openOffice to see the table which you have created using SQL command in the list of the tables in your database. you just click the view menu and the refresh tables option, the newly created table will be enlisted and displayed. But thanks for providing us such a useful and informative video tutorial. I wish you all success.🙏

[@SwatiChawlaofficial]

Right Thanks

[@devanshigoyal4392]

Swati ma'am U r soo very grt I understood each nd everything v. easily Nd found ur teaching very simple and interesting Thnku soo much ma'am for such a wonderful✨😍 session 🥰🙏🏻

[@SwatiChawlaofficial]

Thanks and Welcome

[@jitendrasingh236]

Swati mam,I really have watched all vdos but today I watched ur vdo and SQL is just crystal clear .... Tomorrow is my pre board and I'll give my best mam thanku💖

[@SwatiChawlaofficial]

Glad it helped!!! Thanku so much.. Best Wishes for your exam...

[@NehaSharma-xh9fu]

Explained marvelously 🤲 thank you so much❤️🙌

[@SwatiChawlaofficial]

Thanks and Welcome

[@sanjaykumar-hj7jj]

Because of you i get 30 Marks In my practice exam thankyou very much 💐💐

[@SwatiChawlaofficial]

Congratulations 👏🎉

[@mansiverma1191]

East and West Swati Mam is the best IT teacher like Digraj Sir. I am big fan of Digraj sir and now become fan of Swati Mam too . Thank you so much mam It's very very helpful.

[@SwatiChawlaofficial]

Thanks and Welcome

[@rakeshreddy3959]

Ma’am this video was very helpful for my IT practical. Thank u ma’am for this wonderful video😊😊😊

[@SwatiChawlaofficial]

Most welcome 😊

[@AnilKumar-fl7ti]

Mam it's the only topic which seemed too hard to me....but after watching ur video it seems literally interesting and easy..... thanks a lot☺️

[@adityaswaroop823]

Indeed

[@factexploded2953]

3: Violation of unique constraint SYS_PK_53: duplicate value(s) for column(s) ROLLNO

[@niketdhariwal6485]

finally i understood it i was struggling to understand this concept from last 2 months thankuu mam

[@SwatiChawlaofficial]

Glad it was helpful!! Keep Watching 😀

[@sagarbindal8020]

She is a genius I am now cleared this topic

[@SwatiChawlaofficial]

Thanku

[@swastiksingh8199]

Thank you so much mam......Tomorrow is my practical exam and I was in a lot of worry.......But you have cleared all the doubts and I am confident of performing well in the exam. Thank you so much mam!!!

[@SwatiChawlaofficial]

Thanks and Welcome

[@abhishekojha635]

Really liked the content ... suggestions please upload notes for IT and employbility skill

[@SwatiChawlaofficial]

Already uploaded... Please check out the description of the video

[@ananyasablok454]

Thankyou Mam😊 , I have studied from your channel in term 1 and it really went well I wish that your channel will grow more because you are literally amazing ❤❤

[@SwatiChawlaofficial]

Thanks a lot 😊

[@purpleoceanarmygirl7701]

Mam also upload another video 🙏 related to this query because each and every symbol is important to me🙂🙂 .....btw nice explanation 🤗

[@SwatiChawlaofficial]

Database Management System: kzbin.info/aero/PL5Raijva2y4QEsOPmhKXuK1__yKzkuc4e

[@ramvijayverma1743]

Best explanation it ' s helps a lot .thanku mam 😊☺️

[@pearljain1606]

Thank you mam for such clear and precise explanation ☺️

[@SwatiChawlaofficial]

Most welcome 😊

[@parasvarshney_2252]

Mam best explanations I have never take class of this session and tomorrow is my practical Thnx alot mam

[@SwatiChawlaofficial]

Thanks and Welcome... Best wishes for your exam

[@sudhakarsswaraanjali3397]

Thanku maam your videos helped me a lot dueing every exam of my school and boards. You are a great teacher!😄

[@SwatiChawlaofficial]

It's my pleasure

[@reeyagaur5824]

Best Explanation Ever!! ❤❤

[@SwatiChawlaofficial]

Thank you! 😃

[@sanketkumar1028]

Thanks again for your help.

[@NPS001]

, a command is a specific order from a user to the computer's operating system or to an application to perform a service

[@HarshChauhanOfficial11]

Watching 4 hrs before exam

[@manasvigupta8357]

Thank you veryyy muchhh ...........your video reallyy helped me prepare for my practical...........awesome job 👍👍👏👏

[@SwatiChawlaofficial]

Thanks 🙏🏻

[@jashanaggarwal6686]

Mam select sirf in tables pr kaam krega jo SQL commands se bne h lekin dusre commands wizard ya design view vale tables pr kaam krege?

[@YashSingh-nv5cm]

hello thank you for amazing lecture a doubt distinct will not work for primary key right so * can not be used ???

[@SwatiChawlaofficial]

Yes

[@SuhaniGrover-hr7kx]

Thank you ma'am for making my concepts crystal clear☺😄

[@SwatiChawlaofficial]

Most welcome 😊

[@cactusash]

THANK YOU SO MUCH MAAM,THIS REALLY HELPED ME

[@SwatiChawlaofficial]

Thanks and Welcome

[@anonymous-lz8vt]

madam thank you soo much , i had lots of doubt on how to use open office , you got them all cleared

[@SwatiChawlaofficial]

My pleasure.. Keep Watching

[@anonymous-lz8vt]

@@SwatiChawlaofficial maam i had my practical test on 16th , got full marks, all credits to you

[@Lofimusicaana]

Appreciative Effort . Deserves SUBSCRIBE ! ✅

[@SwatiChawlaofficial]

Thanku

[@lewnneymar4018]

I don't know hindi i am tamil hence I could understand and it was very easy

[@abhisheknair7522]

Ma'am... I wish if you was my computer teacher... not gonna lie.. amazing class

[@SwatiChawlaofficial]

Thanku so much 🙏🏻🙂

[@saranyavimalanathan3434]

Thank you soo much ma’am! 💜💜

[@SwatiChawlaofficial]

Welcome

[@riyakamboj1177]

Thankyou mam . awesome explanation. Although I am watching this after 1 yr

[@SwatiChawlaofficial]

Glad to hear that.. Thanks

[@sanketkumar1028]

Thank you so much

[@fitnesswithsr]

Such a nice explanation mam🙏🙏💌

[@SwatiChawlaofficial]

Thanku

[@Shreya12763]

Thank you ma'am...so nicely explained...got each of it😀

[@SwatiChawlaofficial]

Great 👍 Glad it was helpful.. Thanku so much Keep Watching

[@Shreya12763]

@@SwatiChawlaofficial ma'am what will be the syntax if we want to display the salary of all employees after incrementing by Rs 1000

[@Shreya12763]

And also for displaying the salary after incrementing as thrice as the amount of present salary

[@shazia8390]

Best CHANNEL AND HARDWORKING EDUCATOR 🎩🎩 off

[@SwatiChawlaofficial]

Thanku so much.. 🙏🏻🙂

[@ManojKumar-ho5mf]

One of most most important video #must watch

[@SwatiChawlaofficial]

Thanku

[@shriyapatwal6716]

The concept is explained very well, I would definitely not be able to forget this now...thank you for this video ma'am ☺💖

[@SwatiChawlaofficial]

Thanks and Welcome

[@kamalkishorgupta9044]

Thanks so much for clear explanation

[@SwatiChawlaofficial]

You are welcome!

[@ashishjatiani3356]

Thank You so much!!!!!!

[@SwatiChawlaofficial]

You're welcome!

[@vipulgangwani]

Thank you mam It helped a lot for my. IT 402 EXAM ❤️❤️✨✨

[@gamingenergy1898]

Le soniya before(who have 45 marks) - emotional damage Le soniya after marks change to 55- dil garden garden hogya bhot mza aariya h yha p.

[@dhruvmaheta5811]

MAM TOMORROW IS MY IT PRACTICAL EXAM AT 11:40 AM ...THANKYOU MAM

[@SwatiChawlaofficial]

Welcome... All the best

[@nitindahiya5504]

Thanks a lot of you ma'am for this video

[@SwatiChawlaofficial]

Welcome

[@rubypandey400]

Thankyou mam to make this difficult topic easy to me

[@SwatiChawlaofficial]

My pleasure... Keep Watching

[@raghvendrasingh8037]

mam aapka channel badhia hai, exam se ek din pehle bhi dekh leta hun to sab kuch samajh aa jata hai, kher mein exam se ek din pehle hi dekhta hun but still mam aap badhia padhate ho

[@SwatiChawlaofficial]

Thanku so much

[@pitSen2023April]

Very good teaching ,Nice work for students .Thank you

[@SwatiChawlaofficial]

Thanks and Welcome

[@Neongaming264]

Mam after watching your video . I will got 58 no. In 60 no. Paper😊😊😊

[@SwatiChawlaofficial]

😀

[@Neongaming264]

Thankyou

[@virubarak5383]

Thank you mam this video is very helpful to me and my friends

[@SwatiChawlaofficial]

Most welcome 😊

[@hhIsTheBest]

Thank You Ma'am !

[@SwatiChawlaofficial]

Welcome

[@shraddhavarshney9500]

Most most most helpful video on KZbin thank youu soooo muchh mam❤🥺❤

[@SwatiChawlaofficial]

Thanks.. Check out this video as well 😀 kzbin.info/www/bejne/Y16lZamHdrmKkLM

[@tencentbhai3317]

Dhanyawad mam❤

[@SwatiChawlaofficial]

🙏🏻

[@sathishkashyap4151]

It's very Good and Meaningful video. Good Teaching also.

[@SwatiChawlaofficial]

Thanks and welcome

[@Vanshika-Gupta]

Really Good ma'am. Thankyou.

[@SwatiChawlaofficial]

Most welcome 😊

[@prachi8022]

THANKYOU SO MUCH MA'AM!!!

[@SwatiChawlaofficial]

Welcome

[@savitapawar6972]

It really helped a lot

[@SwatiChawlaofficial]

Thanks.. Keep Watching

[@ayushpandey595]

Thanks a lot mam🧡

[@SwatiChawlaofficial]

Welcome

[@funwithrajnandani5378]

Thnx mam Maine phle aur bhi video dekhi thi but samjh nhi aaya Ab aagya bhaut achhe se 🙃

[@devanshsinha9323]

Thanku ma'am ❣️

[@SwatiChawlaofficial]

Welcome

[@laxmisinghh56]

Thankyou so much..💝

[@SwatiChawlaofficial]

Welcome 😊

[@sshaha306]

What will the syntax for inserting value on a specific row ❓#question @swatichawla

[@hemanyamehta3845]

Thankyou mam..helped alot🙂🙂

[@SwatiChawlaofficial]

Welcome

[@Trustworthyone]

Thank you ma'am 🙏🏻

[@SwatiChawlaofficial]

Most welcome 😊

[@aryanchatterjee5826]

thankyou, you deserve more number of subscribers

[@SwatiChawlaofficial]

Welcome... Please share it with others too

[@aryanchatterjee5826]

@@SwatiChawlaofficial yes i will

[@vivekkhandelwal3855]

Mam i have a doubt In book the name of the table is given in " But you directly applied query, why?

[@Sweety12652]

You are really a great Teacher 💝💝

[@SwatiChawlaofficial]

Thank you! 😃

[@yashnamdeo9520]

Thankyou mam ❤

[@SwatiChawlaofficial]

Welcome

[@chandraera]

Mam please reply 🙏 After runny the command as you did in insert into values it is saying column not found: NEHA

[@SwatiChawlaofficial]

Make sure u have to written the values in quotes.. Plzzz recheck it again carefully, as explained in the video

[@fungamer3059]

Ma'am please help.... instead of "command successfully executed" , I'm getting an error " column not found : column name " while using Insert into command

[@SwatiChawlaofficial]

Check out your syntax again..

[@atulaanand2679]

Thank you Mam👍. You deserve millions of subscribes

[@SwatiChawlaofficial]

Thanks a lot 😊

[@ritvendrayadav7406]

Thank you so much mam 🙏🙏

[@SwatiChawlaofficial]

Welcome

[@gauranshisrivastava353]

thank you mam, its very helpful😊

[@SwatiChawlaofficial]

Most welcome 😊

[@usualgamming5372]

Thankyou miss

[@SwatiChawlaofficial]

Welcome

[@akashbinu8666]

Thank you😊

[@SwatiChawlaofficial]

Welcome

[@yuktiagarwal2604]

Thank u mam 🙏🙏

[@SwatiChawlaofficial]

Welcome

[@RamKumar-kw4oe]

Mam how is select a DDL as it just fetches the "VALUES" and does not affect the structure of the table

[@SwatiChawlaofficial]

Yes...it was by Mistake.. Select is a DML Command

[@RamKumar-kw4oe]

@@SwatiChawlaofficial OK mam thanks for your revert NICE TEACHING

[@somisingh2010]

Very well explained.

[@SwatiChawlaofficial]

Thanks