Solve 10 SQL Queries in 10 Minutes | SQL Interview Questions

[@crackconcepts]

Hi, let me know if you want a part 2 of this video. Do check out other videos in the playlist

[@atifahmed9060]

Yes please do part 2 it will be helpful to know more queries and also to practice

[@shubhamanand6640]

Definitely part 2

[@tanayapanda1636]

Yes please make part 2 it is very helpful 🙏

[@ramakrishnasamala4201]

yes want part 2 video. I love you videos they are so helpful

[@mohammadfaisalelahi9826]

yes Sadia plz make part 2

[@KJB-Man]

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! :)

[@crackconcepts]

@@KJB-Man thank you for your kind words :)

[@USA_to_Asia_in_2024]

Great information. Thank You!

[@shaikusman536]

Awsome content sadiya...Keep up the good work....respect from bangalore

[@balamuruganp3865]

Excellent work , i think this video should be renamed to mySQL.

[@sherifelgazar4089]

Great & we need the data set

[@greenleaf695]

Thank you madam. Hopefully we get important videos from you. Best wishes from Bangladesh.

[@vinodsingh-gt5yo]

Tq nice video madam. Release 2d video also it would help me more.

[@nagendrababu2531]

Very helpful , need part2 questions Mam please..

[@dhanasingh4662]

Put the vedio on Difference between stack and heap memory in java

[@PoojaGupta-ge7uz]

Yes please make part 2 of this sql queries video

[@tejavathsuresh5563]

could you please make video on " joint " and " set operator" and " analytical function " with an complex example

[@robinrakesh3204]

Plz do more videos regarding SQL queries

[@mubinshaik19]

Ossem video nd easy to understand sadiya👍👍

[@karansachdeva8516]

Thank you so much. Great explanation. Yes please create Part-2 also :-)

[@gunasekar4098]

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?

[@mahfuzadil5076]

THANK YOU VERY INFORMATIONAL VIDEO. WILL YOU PLEASE MAKE VIDEO ON HOW TO USE THE LIMIT AND OFFSET COMMANDS ON SQL-DEVELOPER PLEASE.

[@suryanshsinghkarchuli9892]

part 2 neeeded, keep creating content

[@thavadaboinabhuvaneshwar9581]

I learnt new things in SQL queries with this video, thank you

[@deveshmehare279]

thank you Dear

[@ramakrishnasamala4201]

Great Explanation

[@dharanikumar1536]

Yes plz do it it's very helpful

[@santhoshm7584]

For the 4th querry, can we use TRUNCATE table to the tmp table????

[@SureshMarri-bz1pz]

Tq❤❤❤❤

[@paragroy5359]

Really nice video...

[@raghavabathula5080]

Mam could you please answer this "write a query to find who has been in the company for the longest ?? "

[@UpendraYadav-te8ov]

Tq nice explanation we want part 2

[@sensibleandhrite]

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.

[@abhishekmundrawale7633]

SELECT MAX(temperature) as Max_Temp FROM citytemp execute this query you will get your ans....

[@amanbhargavaofficial]

Thank you😊😊😊😊😊😊😊😊

[@MEENA-SUITS-KOLKATA]

sadia mam how did you imported the emp table in mysql

[@surajpatil3579]

Thanks for this waiting for part 2

[@manikhantayema2395]

Pls do more videos about sql tq mam

[@MuhammadUmairShaykh]

Good bouy

[@sakshisingh-nt8re]

Thankyou soo much for this info

[@mohammadsubhanqazi599]

Why don't you use a semi-colon in the end of each clause

[@pritamjadhav9660]

Plz querys on sql server

[@programit7155]

3:41 SELECT * INTO #EmployeeCopy from Employee

[@monishbabu5065]

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

[@gokhanyalcin1398]

hey I have a qestion, Can you please explain what is the meaning of the 'N"? I am talking about question 5, I appreciated

[@payalia08]

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?

[@gsinghal6933]

Please teach R languague complete course and Python also

[@ravisharma-ze7dk]

Madam please bataye ki query aaplog kaise samjte h ki ye likhna h

[@saikumar-os2rg]

can we have a data

[@olxolx203]

Where is the link for Part 2

[@jayasribharadwaj5017]

In question no. 10, after finding out the duplicate entries is there any way to delete the duplicate entries from the table?

[@crackconcepts]

There’s an entire video on deleting duplicates. Search on my channel, you’ll find it :)

[@jayasribharadwaj5017]

@@crackconcepts okay! 😊

[@manikhantayema2395]

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

[@manikhantayema2395]

Sry not septic that is deptid Typing mistake mam

[@Prasad10101010]

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

[@manikhantayema2395]

@@Prasad10101010 tq brother it's executed tq so much

[@swaroopmadeti372]

@@Prasad10101010 bro how get depth knowledge in sql?

[@kapiljain7596]

We are not able to see it properly. Pls upload the videos with big fonts

[@manikhantayema2395]

Hai mam First comment Tq for ur videos

[@ankitpurshottam3442]

kindly try to provide dataset

[@mahalakshmivembu9288]

Power bi video pls

[@DineshKumar-hi7fh]

HOW TO DELETE DUPLICATE RECORD FROM TABLE IN DIFFERENT WAYS ?

[@ahmadfouad3786]

can you explain correlated queries please?

[@Pkthefoodie]

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

[@pradeepmn3289]

Please share working file..too. it's good practice for us to.. plz

[@prasadsatre6119]

Hello ma'am I have some queries

[@anonymouskunal2748]

Nice..♥️✌🏻😍

[@basicmaths3443]

can you help me in solving this?

[@Khader_views]

Kindly let me know im looking online class for sql db

[@raquibshaik7835]

Contact,, sry ..concat concat..