Hi, let me know if you want a part 2 of this video. Do check out other videos in the playlist
@atifahmed90603 жыл бұрын
Yes please do part 2 it will be helpful to know more queries and also to practice
@shubhamanand66403 жыл бұрын
Definitely part 2
@tanayapanda16363 жыл бұрын
Yes please make part 2 it is very helpful 🙏
@ramakrishnasamala42013 жыл бұрын
yes want part 2 video. I love you videos they are so helpful
@mohammadfaisalelahi98263 жыл бұрын
yes Sadia plz make part 2
@KJB-Man3 жыл бұрын
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! :)
@crackconcepts3 ай бұрын
@@KJB-Man thank you for your kind words :)
@USA_to_Asia_in_20243 ай бұрын
Great information. Thank You!
@shaikusman536 Жыл бұрын
Awsome content sadiya...Keep up the good work....respect from bangalore
@balamuruganp38652 жыл бұрын
Excellent work , i think this video should be renamed to mySQL.
@sherifelgazar4089 Жыл бұрын
Great & we need the data set
@greenleaf6953 жыл бұрын
Thank you madam. Hopefully we get important videos from you. Best wishes from Bangladesh.
@vinodsingh-gt5yo2 жыл бұрын
Tq nice video madam. Release 2d video also it would help me more.
@nagendrababu25313 жыл бұрын
Very helpful , need part2 questions Mam please..
@dhanasingh46623 жыл бұрын
Put the vedio on Difference between stack and heap memory in java
@PoojaGupta-ge7uz2 жыл бұрын
Yes please make part 2 of this sql queries video
@tejavathsuresh55633 жыл бұрын
could you please make video on " joint " and " set operator" and " analytical function " with an complex example
@robinrakesh32043 жыл бұрын
Plz do more videos regarding SQL queries
@mubinshaik193 жыл бұрын
Ossem video nd easy to understand sadiya👍👍
@karansachdeva85163 жыл бұрын
Thank you so much. Great explanation. Yes please create Part-2 also :-)
@gunasekar40983 жыл бұрын
Hi really happy to hear your teaching skill And explanation.. 👍
@_Pandyachinmay Жыл бұрын
Hey. Can’t we use the Union all for the last question to get all the duplicates value?
@mahfuzadil50763 жыл бұрын
THANK YOU VERY INFORMATIONAL VIDEO. WILL YOU PLEASE MAKE VIDEO ON HOW TO USE THE LIMIT AND OFFSET COMMANDS ON SQL-DEVELOPER PLEASE.
@suryanshsinghkarchuli98922 жыл бұрын
part 2 neeeded, keep creating content
@thavadaboinabhuvaneshwar95812 жыл бұрын
I learnt new things in SQL queries with this video, thank you
@deveshmehare279 Жыл бұрын
thank you Dear
@ramakrishnasamala42013 жыл бұрын
Great Explanation
@dharanikumar15363 жыл бұрын
Yes plz do it it's very helpful
@santhoshm75842 жыл бұрын
For the 4th querry, can we use TRUNCATE table to the tmp table????
@SureshMarri-bz1pzКүн бұрын
Tq❤❤❤❤
@paragroy53592 жыл бұрын
Really nice video...
@raghavabathula50803 жыл бұрын
Mam could you please answer this "write a query to find who has been in the company for the longest ?? "
@UpendraYadav-te8ov3 жыл бұрын
Tq nice explanation we want part 2
@sensibleandhrite3 жыл бұрын
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.
@abhishekmundrawale76333 жыл бұрын
SELECT MAX(temperature) as Max_Temp FROM citytemp execute this query you will get your ans....
@amanbhargavaofficial2 жыл бұрын
Thank you😊😊😊😊😊😊😊😊
@MEENA-SUITS-KOLKATA2 жыл бұрын
sadia mam how did you imported the emp table in mysql
@surajpatil35793 жыл бұрын
Thanks for this waiting for part 2
@manikhantayema23953 жыл бұрын
Pls do more videos about sql tq mam
@MuhammadUmairShaykh3 ай бұрын
Good bouy
@sakshisingh-nt8re3 жыл бұрын
Thankyou soo much for this info
@mohammadsubhanqazi5993 жыл бұрын
Why don't you use a semi-colon in the end of each clause
@pritamjadhav96603 жыл бұрын
Plz querys on sql server
@programit71553 жыл бұрын
3:41 SELECT * INTO #EmployeeCopy from Employee
@monishbabu50653 жыл бұрын
Yes part 2 n part 3
@MAMAKIJAANGUGU Жыл бұрын
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
@gokhanyalcin13982 жыл бұрын
hey I have a qestion, Can you please explain what is the meaning of the 'N"? I am talking about question 5, I appreciated
@payalia083 жыл бұрын
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?
@gsinghal69333 жыл бұрын
Please teach R languague complete course and Python also
@ravisharma-ze7dk3 жыл бұрын
Madam please bataye ki query aaplog kaise samjte h ki ye likhna h
@saikumar-os2rg3 жыл бұрын
can we have a data
@olxolx2032 жыл бұрын
Where is the link for Part 2
@jayasribharadwaj50173 жыл бұрын
In question no. 10, after finding out the duplicate entries is there any way to delete the duplicate entries from the table?
@crackconcepts3 жыл бұрын
There’s an entire video on deleting duplicates. Search on my channel, you’ll find it :)
@jayasribharadwaj50173 жыл бұрын
@@crackconcepts okay! 😊
@manikhantayema23953 жыл бұрын
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
@manikhantayema23953 жыл бұрын
Sry not septic that is deptid Typing mistake mam
@Prasad101010103 жыл бұрын
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
@manikhantayema23953 жыл бұрын
@@Prasad10101010 tq brother it's executed tq so much
@swaroopmadeti3723 жыл бұрын
@@Prasad10101010 bro how get depth knowledge in sql?
@kapiljain75963 жыл бұрын
We are not able to see it properly. Pls upload the videos with big fonts
@manikhantayema23953 жыл бұрын
Hai mam First comment Tq for ur videos
@ankitpurshottam3442Ай бұрын
kindly try to provide dataset
@mahalakshmivembu92883 жыл бұрын
Power bi video pls
@DineshKumar-hi7fh3 жыл бұрын
HOW TO DELETE DUPLICATE RECORD FROM TABLE IN DIFFERENT WAYS ?
@ahmadfouad37863 жыл бұрын
can you explain correlated queries please?
@Pkthefoodie2 жыл бұрын
Mam in SQL server 6 th question data not inserting showing incorrect syntax ... Why mam ?
@neenneen2288 Жыл бұрын
How u getting it jobs im not getting job in it sector..😠😡 entry level job sigtilla.. Wasted my degree in other field jobs
@pradeepmn32893 жыл бұрын
Please share working file..too. it's good practice for us to.. plz
@prasadsatre61192 жыл бұрын
Hello ma'am I have some queries
@anonymouskunal27483 жыл бұрын
Nice..♥️✌🏻😍
@basicmaths34433 жыл бұрын
can you help me in solving this?
@Khader_views3 жыл бұрын
Kindly let me know im looking online class for sql db