referenced table or referencing table , do not have any role in that. The attribute by which the grouping will happen, should be present in Select Clause (it belongs to the table mentioned in FROM clause).
Other all queries are correct what I written without seeing only I checked my answers but j question one I wrote is different that's why I am asking and you explains very well thank you mam 😊 so much ❣️
@@rishikawanwar2589 It's good that you have written it yourself. In j part, what you have written only specifies job as manager. But the question has two requirements, job as manager and name as Amyra. That is why we have to add the condition I told you in comment.
20:59 done for today 🎉
mam, in group by clause...the attribute by which the grouping will happen...should belong from where, referenced table or referencing table...
referenced table or referencing table , do not have any role in that.
The attribute by which the grouping will happen, should be present in Select Clause (it belongs to the table mentioned in FROM clause).
J question me select employee_name , job_title where job_title = "manager"; correct hai kya mam
@@rishikawanwar2589 Before ; add
AND employee_name = "Amyra"
Mam didn't understand 😔
Is that query is incorrect what I have written
Other all queries are correct what I written without seeing only I checked my answers but j question one I wrote is different that's why I am asking and you explains very well thank you mam 😊 so much ❣️
@@rishikawanwar2589 It's good that you have written it yourself.
In j part, what you have written only specifies job as manager. But the question has two requirements, job as manager and name as Amyra. That is why we have to add the condition I told you in comment.
37:04 will the grouping happen if we use the attribute "Dept_Name" instead of "Dept_No"??
Yes
thank you so much madam litreally never opwnd the book before but still so confident about tomorrows paper only because of you!!
Great! You're welcome ✨
Tq Sir And Mam For Nice Explanation
You're most welcome
Its too much helpful ❤
Thanks ✨
Ma'am how to fetch all the fields of tha table?
Please bata dijiye ye mujhe bilkul bhi nhi aa rha h 🥲
Select * from
❤ helpful.
Mam revision kr dijiye nah short way may.... ❤
Revision video will be uploaded soon.
mam plz upload one shot video
@@GunjanAgarwal17 soon 👍🏻
mam join wali command smj m hi nhi ayi
What were you unable to understand?
Mam query se kese question aynege plz mam help
ruclips.net/video/MGr4PGMCozM/видео.htmlfeature=shared
Mam bahut dar lag raha h mam mara ko kuch nahi aa raha plz help kar dijya plzzzz😢
The complete IT playlist is available in playlists section. You can complete playlist on RUclips
Ma’am can I join in the evening sesh if there is ?