Appreciate the efforts. Your videos have helped me a lot. But, it would be really helpful if you could edit the video or fetch in new one with the correction. I am sure many people are not reading comments. I got confused at first when you joined on emp_id on both ends. Thank you Sadia
Thanks Sadia, recreating the video will be more helpful as not everyone will be visiting the comment section. It may mislead them. Btw thanks a lot for all your videos. Very much helpful and easy to understand 😊
@@sahilbhatia2671 i meant if you were to find the employees who are not manager with not in statement, then it will not give you the correct result, try it yourself
your way of teaching is amazing. explaining using query helped me to understand the purpose. i have seen videos explaining self join but this really made me understand the purpose and how to use it.
Hey, the contents are too good.. just one suggestion, It would be great if write queries into details part, as sometime the query and the table details are not visible.
@@BHARATHEEYUDU. that's not possible.. I don't have a interval of dates to use between.. I just want to find who was the last joinee.. there can be more thn one employees joined on same date.. I need the last one
Filter record in where clause Where Joining Date < Given Date Then use order by on your identity column in desc order. Select Top 1 * from employee Where joiningdate < givendate Order by employeeid desc
I have two tables both have same records but in one table for no records inserted blank values but for another table no records, inserted null values which is okay . How can compare both tables and considering black values are equivalent to null values respectively
Bro/sis :- consider table as employee!!!! If there is column place and district,in between if we need to add column “city” in between “place” and “district” use following:- _____________________ alter table employee add city varchar(30) after place; __________________ if we use:- __________________ alter table employee add age int ; __________________ Will add in last position. to change column name place to places _______________________ alter table employee change place places varchar(30); _______________________ Sorry if it’s wrong 😑
Hi, there’s a small correction.
The condition should be
ON e.empid = m.man_id;
Do more videos mam
Appreciate the efforts.
Your videos have helped me a lot.
But, it would be really helpful if you could edit the video or fetch in new one with the correction.
I am sure many people are not reading comments.
I got confused at first when you joined on emp_id on both ends.
Thank you Sadia
yupp.
What will be the count of rows if we have single column in both the table
Thanks Sadia, recreating the video will be more helpful as not everyone will be visiting the comment section. It may mislead them. Btw thanks a lot for all your videos. Very much helpful and easy to understand 😊
Can we also use inner query like
select emp_id from employee where emp_id IN (select manager_id from employee);
Another way of doing it
Select emp_id from employee
Where emp_id in (select distinct man_id from employee)
This will create issue where mgr_id is null
@@trishjais i dont think so because we can have null values in the list but it wont effect in statement
@@sahilbhatia2671 i meant if you were to find the employees who are not manager with not in statement, then it will not give you the correct result, try it yourself
Your videos are like quick recaps for concepts , thank you
We can use either IN or Exists as well to achieve the same
it should be e.empid=m.managerid.
your way of teaching is amazing. explaining using query helped me to understand the purpose. i have seen videos explaining self join but this really made me understand the purpose and how to use it.
Joining clause is wrong , it should be e.emp_id=m.mgr_id
exactly in every video i saw some mistakes .
inner join should be on man_id not with empid itself
Well explained, these videos are like revision to me thank you
Please do some videos on real-time related query
Hey, the contents are too good.. just one suggestion, It would be great if write queries into details part, as sometime the query and the table details are not visible.
select empid from employees where empid=man_id; ( without self join )
Hi.. I have a doubt.. like how to find the last employee who joined company before a given date say 10/01/21..
Use between operator
@@BHARATHEEYUDU. that's not possible.. I don't have a interval of dates to use between.. I just want to find who was the last joinee.. there can be more thn one employees joined on same date.. I need the last one
Filter record in where clause
Where Joining Date < Given Date
Then use order by on your identity column in desc order.
Select Top 1 * from employee
Where joiningdate < givendate
Order by employeeid desc
@@IQBees that sounds right 👍
all videos are easy and simple to understand..good work.
Who are mangers or who are also managers? I think who are mangers from the employee table
Thanks alot for the knowledge you sharing and teaching sql concepts so simple but highly understandable. Appreciate your great effort.
Abe galat pada rakha h
Transfer the employees from department 10 to 20?
Which syntax we can at this place
I have a question: How to display no of 'L' in each name? Like counting the char in name using SQL query
Hi do you conduct sql classes.. On scenarios based plz do let m know.
HI, I GOT A ERROR LIKE Ambiguous column name 'CITY'. CAN YOU HELP ME WITH IT?
u make it easy good work as always
Awesome is your explanation
E.EmpId=M.Man_id right ?
I have two tables both have same records but in one table for no records inserted blank values but for another table no records, inserted null values which is okay . How can compare both tables and considering black values are equivalent to null values respectively
Use ISNULL(ColumnName,'') to compare
How to add new column at specific position
ALTER TABLE by default adds new columns at the end of the table. Use the AFTER directive to place it in a certain position within the table:
Bro/sis :- consider table as employee!!!!
If there is column place and district,in between if we need to add column “city” in between “place” and “district” use following:-
_____________________
alter table employee add city varchar(30) after place;
__________________
if we use:-
__________________
alter table employee add age int ;
__________________
Will add in last position.
to change column name place to places
_______________________
alter table employee change place places varchar(30);
_______________________
Sorry if it’s wrong 😑
I mailed you one problem statement, Can you make a video on the same.
And database Ko secure kaisa rkha jay k wo crash na ho
Mam could u pls say the output after that query?
U r so good Sadiya Appi.....
Miss Kiya ap notes provide kr sakti h sql k urdu m i will pay you
Select * from employee where emp_id = man_id ?
Is it right or not
Nope..Its not correct..That will give you no result unless an employee is manager to himself..
@@mohanmurali4138 we have to fetch the employee who is manager then how it is wrong
easiest solution found so far
Hi madam, can you please able to provide all notes scanned pdf
Good
Great I like your consistency in uploading video
Super
thanks so much!
Your explanation is awesome
I found this video in recommendation.
I think I have found gold 💜
Actually.....I am only in grade 7 so I don’t need to watch these....
But I still viewed all your videos cause of your voice....so cute 😘😘