Excellent work! You are on course to have a prosperous future in software engineering and/or database design engineer. I use to mange a large group of software engineers and I would have been happy to have had you in my group! I have been programming since the caveman days and have not found many with your in depth understanding of relational logic and database design. Please keep posting your videos! :)
I have to load multiple excel files to sql server's table by doing left join using ssis and ssms can you help me with it, how to do it? And also can you tell how to add those columns like created by,updated by,created date and updated date by derived column in ssis?
I dont understand why Im not able to do the last query. It doesn’t let me select all records from a table. Even Im using mysql and there are 3 duplicate records. I have to use count in select and can’t retrieve * records
SELECT MAX(temperature),city FROM citytemp GROUP BY CITY; MAAM why does this give the maximum temperature of each city.Can you explain how it works step by step?Why is that it will not fill every row in temperature column of the result with just one value i.e maximum temperature of that entire column?why does it give city wise max temperature? please explain. Struggling with getting any intuition.
Mam please help me mam.i have asked a question in interview..i. e... In 1 table contains columns.. Septic, deptname and another table empid, empname and deptid which is foreignkey of first table(column deptid). My question was...Display department which has maximum employees? Please write a query mam.i hope u will do this for my help Tq Tq
Try below query: SELECT * FROM ( SELECT dept_name, COUNT(empid) as 'No_of_Emp' FROM table1 as emp, table2 as dept WHERE emp.deptid=dept.deptid GROUP BY dept_name ORDER BY No_of_Emp DESC) WHERE ROWNUM = 1
Hi, let me know if you want a part 2 of this video. Do check out other videos in the playlist
Yes please do part 2 it will be helpful to know more queries and also to practice
Definitely part 2
Yes please make part 2 it is very helpful 🙏
yes want part 2 video. I love you videos they are so helpful
yes Sadia plz make part 2
Hi really happy to hear your teaching skill
And explanation.. 👍
Thank you madam. Hopefully we get important videos from you. Best wishes from Bangladesh.
Thank you so much. Great explanation.
Yes please create Part-2 also :-)
Great information.
Thank You!
Very helpful , need part2 questions Mam please..
Excellent work! You are on course to have a prosperous future in software engineering and/or database design engineer. I use to mange a large group of software engineers and I would have been happy to have had you in my group! I have been programming since the caveman days and have not found many with your in depth understanding of relational logic and database design. Please keep posting your videos! :)
@@paulparadise6059 thank you for your kind words :)
Awsome content sadiya...Keep up the good work....respect from bangalore
could you please make video on " joint " and " set operator" and " analytical function " with an complex example
Ossem video nd easy to understand sadiya👍👍
Great Explanation
Thank you so much for this❤️
THANK YOU VERY INFORMATIONAL VIDEO. WILL YOU PLEASE MAKE VIDEO ON HOW TO USE THE LIMIT AND OFFSET COMMANDS ON SQL-DEVELOPER PLEASE.
Plz do more videos regarding SQL queries
Great & we need the data set
Excellent work , i think this video should be renamed to mySQL.
Tq nice explanation we want part 2
Thankyou soo much for this info
Really nice video...
Tq nice video madam. Release 2d video also it would help me more.
Yes plz do it it's very helpful
thank you Dear
part 2 neeeded, keep creating content
Thanks for this waiting for part 2
Good bouy
Put the vedio on Difference between stack and heap memory in java
Yes please make part 2 of this sql queries video
Pls do more videos about sql tq mam
Nice..♥️✌🏻😍
Hai mam First comment
Tq for ur videos
sadia mam how did you imported the emp table in mysql
Yes
part 2 n part 3
For the 4th querry, can we use TRUNCATE table to the tmp table????
Hey. Can’t we use the Union all for the last question to get all the duplicates value?
Thank you😊😊😊😊😊😊😊😊
I have to load multiple excel files to sql server's table by doing left join using ssis and ssms can you help me with it, how to do it? And also can you tell how to add those columns like created by,updated by,created date and updated date by derived column in ssis?
Please teach R languague complete course and Python also
can we have a data
hey I have a qestion, Can you please explain what is the meaning of the 'N"? I am talking about question 5, I appreciated
Why don't you use a semi-colon in the end of each clause
Mam could you please answer this "write a query to find who has been in the company for the longest ?? "
Where is the link for Part 2
can you explain correlated queries please?
Plz querys on sql server
I learnt new things in SQL queries with this video, thank you
I dont understand why Im not able to do the last query. It doesn’t let me select all records from a table. Even Im using mysql and there are 3 duplicate records. I have to use count in select and can’t retrieve * records
Power bi video pls
Madam please bataye ki query aaplog kaise samjte h ki ye likhna h
Kindly let me know im looking online class for sql db
HOW TO DELETE DUPLICATE RECORD FROM TABLE IN DIFFERENT WAYS ?
Hello ma'am I have some queries
We are not able to see it properly. Pls upload the videos with big fonts
can you help me in solving this?
In question no. 10, after finding out the duplicate entries is there any way to delete the duplicate entries from the table?
There’s an entire video on deleting duplicates. Search on my channel, you’ll find it :)
@@crackconcepts okay! 😊
Please share working file..too. it's good practice for us to.. plz
Mam in SQL server 6 th question data not inserting showing incorrect syntax ... Why mam ?
How u getting it jobs im not getting job in it sector..😠😡 entry level job sigtilla.. Wasted my degree in other field jobs
SELECT MAX(temperature),city FROM citytemp GROUP BY CITY;
MAAM why does this give the maximum temperature of each city.Can you explain how it works step by step?Why is that it will not fill every row in temperature column of the result with just one value i.e maximum temperature of that entire column?why does it give city wise max temperature? please explain. Struggling with getting any intuition.
SELECT MAX(temperature) as Max_Temp FROM citytemp execute this query you will get your ans....
3:41
SELECT * INTO #EmployeeCopy from Employee
Contact,, sry ..concat concat..
Mam please help me mam.i have asked a question in interview..i. e... In 1 table contains columns.. Septic, deptname and another table empid, empname and deptid which is foreignkey of first table(column deptid).
My question was...Display department which has maximum employees? Please write a query mam.i hope u will do this for my help Tq Tq
Sry not septic that is deptid
Typing mistake mam
Try below query:
SELECT * FROM (
SELECT dept_name, COUNT(empid) as 'No_of_Emp'
FROM table1 as emp, table2 as dept
WHERE emp.deptid=dept.deptid
GROUP BY dept_name
ORDER BY No_of_Emp DESC)
WHERE ROWNUM = 1
@@Prasad10101010 tq brother it's executed tq so much
@@Prasad10101010 bro how get depth knowledge in sql?