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
Thank you madam. Hopefully we get important videos from you. Best wishes from Bangladesh.
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 :)
Hi really happy to hear your teaching skill
And explanation.. 👍
could you please make video on " joint " and " set operator" and " analytical function " with an complex example
Very helpful , need part2 questions Mam please..
Thank you so much. Great explanation.
Yes please create Part-2 also :-)
Awsome content sadiya...Keep up the good work....respect from bangalore
THANK YOU VERY INFORMATIONAL VIDEO. WILL YOU PLEASE MAKE VIDEO ON HOW TO USE THE LIMIT AND OFFSET COMMANDS ON SQL-DEVELOPER PLEASE.
Great information.
Thank You!
Ossem video nd easy to understand sadiya👍👍
Excellent work , i think this video should be renamed to mySQL.
Great Explanation
Plz do more videos regarding SQL queries
Great & we need the data set
Tq nice video madam. Release 2d video also it would help me more.
Thank you so much for this❤️
For the 4th querry, can we use TRUNCATE table to the tmp table????
Put the vedio on Difference between stack and heap memory in java
Tq nice explanation we want part 2
Hey. Can’t we use the Union all for the last question to get all the duplicates value?
part 2 neeeded, keep creating content
Yes please make part 2 of this sql queries video
Yes plz do it it's very helpful
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?
Really nice video...
Thanks for this waiting for part 2
Mam could you please answer this "write a query to find who has been in the company for the longest ?? "
Good bouy
Pls do more videos about sql tq mam
Thankyou soo much for this info
thank you Dear
sadia mam how did you imported the emp table in mysql
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
Hai mam First comment
Tq for ur videos
Nice..♥️✌🏻😍
Yes
part 2 n part 3
can you explain correlated queries please?
Please teach R languague complete course and Python also
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
Madam please bataye ki query aaplog kaise samjte h ki ye likhna h
Thank you😊😊😊😊😊😊😊😊
HOW TO DELETE DUPLICATE RECORD FROM TABLE IN DIFFERENT WAYS ?
can we have a data
Plz querys on sql server
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! 😊
Where is the link for Part 2
Power bi video pls
I learnt new things in SQL queries with this video, thank you
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....
can you help me in solving this?
Hello ma'am I have some queries
We are not able to see it properly. Pls upload the videos with big fonts
Kindly let me know im looking online class for sql db
Please share working file..too. it's good practice for us to.. plz
3:41
SELECT * INTO #EmployeeCopy from Employee
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
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?
Contact,, sry ..concat concat..