Could please try to solve this type of query in SQl server so may be more effective to understand for all us.... Bye the way good content and lot of thanks 😊
Mam I have a 1 question In a table mujhe first name mein sirf name insert krne h jaise saurav And saurav k jgh Gaurav krne h mujhe to iska kya query hoga plz reply me mam
love th way u explain, Mashallah❤️ May ALLAH increase you in knowledge of this deen and dunya
I have been binge watching your SQL videos, really appreciate you sharing. Very helpful!
Thank you for sharing your knowledge!
Thanks a lot.. by going through your tutorial, I was able to crack 2 interview.
Thanks a lot :) keep doing the good work.
So happy for you! 😊
:)
Well explained, I have improved alot by ur videos, tq so much
Could please try to solve this type of query in SQl server so may be more effective to understand for all us....
Bye the way good content and lot of thanks 😊
please do some questions on Date and time , to find that the given time is falling in the range of some time period..
we should write count(*) >= 1 not just > 1. Thanks for your videos really helpfullllllll.
Your voice is awesome and explaintion is pretty good 🙂
Love it...
Hi, can you please post your displayed sheets in Google drive and share the link in description
Super Nanbha👍
Mam can u explain how compiler select top 3 did it compare with any thing
What should we do if there r duplicates in the top 3
In last question, can we use limit? To achieve the 3 top marks?
You can use limit as well, limit works in MySQL whereas Top is used in SQL Server.
@@amolmetkar5627 thanks, i m using mysql so i was thinking its new way to do it without limit, thnx for info
Why we have to use Max(salary), why not salary>=5000 ? At the end.
👍👍👍
Select * from employee order by sal
Where rownum
I have a doubt in 3rd question....in this question we have find top 3 marks....can we use dense_rank function for find the top three marks or not?
Yes, we can use.
@@victormendis2630 ok ...thank you
Also limit 3 can be used I think.
Thanks !!!
Thank you 😁
Give me all commands explain miss
Mam I have a 1 question
In a table mujhe first name mein sirf name insert krne h jaise saurav And saurav k jgh Gaurav krne h mujhe to iska kya query hoga plz reply me mam
U can use update
last query can also be like => select marks from student order by marks desc limit 3;
Remove only middle * From below
****Hello****World****
Please give me the query...