SQL Server Top 30 Interview Questions (in HINDI)

1. Full .NET Interview Course (with PDF Book)
C# / ASP.NET Core / MVC / API - Top 500 Interview Questions
www.udemy.com/course/csharp-o...
Don't worry if course not helping you, Udemy has 30 days Free Refund Policy.
2. Quick Revision Book (PDF format)
Top 500 .NET Interview Questions - OOPS/ C#/ ASP.Net/ MVC/ SQL /.Net Core /Web API
imojo.in/interviewhappy
50% Discount Applied on above link.
Don't worry if book not helping you, I will return 100% of your money with in 7 days of purchase. Just mail me at [e-mail].
My best wishes are with you.

[@diganttrivedi3024]

Amazing boss.....
Very easily to crack interview.
Thank you so much...😊

[@nandakumarpb]

Very helpful content. Just pointing out that, If, I am not wrong, we can use stored procedure in a select statement provided that SP return a result set.

[@ajaybhandari9596]

Nice video , thank you sir.
Love from chamoli (uttarakhand) !!

[@itspraveenkp1960]

Very helpful video, ye sab video se mujhe to job mil gayi, because statement to yaad hone se nahi raha but code he explain kar do interviewer ko to jyada easy padta hai😀😀

[@yogeshroy7978]

Love you sir what an explanations of all your videos on interview. Love from Odisha...

[@poojagaikwad8781]

Hi Happy Sir, aapke explanation kaafi ache aur in-detail hote hai, toh please can you make videos on sql query interview Q&A for beginners as well as experienced people.

[@mehtabidreesi7942]

osm and simple explanation wowwwww big respect

[@radhashukla9159]

As always.....just WAOOO😊

[@arvindraghav1]

Please make videos on design patterns.

[@poojashinde9416]

Really appreciate your efforts nd knowledge thank you 😊 sir

[@interviewhappyrawat]

Thanks and welcome@ pooja

[@guruprasadnalawade]

R u preparing to IT job?

[@omkarbelpatre5]

Thank you so much sir

[@Rudrasharma38281]

nice video sir
API aur webservice me difference ka ek example bataye please

[@ravirajverma6703]

Thank you sir....save my time for interview preparation

[@mayurnehe4276]

Thank u so much sir is very helpful 👏

[@shoukatmalik6013]

Thanks for very detailed session

[@interviewhappyrawat]

My pleasure! @shoukatmalik6013

[@hintsoftware]

Dear Sir,
I am trying for FIFO Stock Valuation as follows using your taught methods like cte and window functions. but not getting done so far. If possible please help us solving this below case solved in a separate video which can be very fast even for lacs of records.
Input Table:
DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 ?
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 ?
14 12/29 150 ?
We need to populate the data according to FIFO method as following:

for 1st OutQty(13 Pcs)=12 Pcs @12.50+1Pcs*10.20=160.20/13=13 Pcs@12.32

for 2nd OutQty(25 Pcs)=25 Pcs @ 10.20 (Because 2nd InnQty has still sufficient Left(50-1-25)=24Pcs for next outqty)

for 3rd OutQty(150 Pcs)=24 Pcs @10.20+100Pcs*11.25+26 Pcs*11.25 (From Last InnQty as there is no more InnQty left) =1662.30/150=150Pcs@11.08

Output Query by CTE, Running Total and window functions Approach:
DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 12.32
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 10.20
14 12/29 150 11.08

Regards-
Sanjeeb

[@manpreetkaur3258]

Sir , do you have sql server Vedio for dba interview

[@sujit03011979ify]

Only one null value allowed in Unique constraint please elaborate as in table multiple null allowed with unique constraint.

[@deveshprasad855]

sir its very helpful in interview , thanks

[@interviewhappyrawat]

Glad to hear that

[@kishoredas9171]

Great

[@deepikakashliwal8855]

Could you please share Azure interview questions videos or links

[@mzama786]

Thanks sir

[@sk_ashadul_islam]

To find nth highest salary, if it is asked for parameterized, the mentioned query will not work, so in that case we can use row_number or if asks for duplicate also then we can use dense_rank 🙂
Ex:
SELECT
employee_id,
first_name,
last_name,
salary,
DENSE_RANK() OVER (
ORDER BY salary DESC
) salary_rank
FROM
employees;

[@veerkunwarsingh9632]

Sir , I have an issue in the question ( difference between SP and Functions ) Point number 4 .
Sir Sp can allow Select as well as DML operation too , but functions support only select statement .
Is this correct ? Or your answer is correct ? ..please clear my confusion .

[@pramodpandey6011]

Awesome

[@avinashpatil1175]

one more sql questons and answeers session is requied so pls make it

[@meerasoftech8445]

Hi sir aapke video Jo udemy par dekhta hun mobile me chalata hun to har video pe feedback option AA Raha ha iska koi solution ki bar bar nahi aate? Aise padhne me dikkat hota h sir

[@omkarbelpatre5]

Fabulous

[@sufiyanpatel6241]

Amazing Video 👍👌

[@interviewhappyrawat]

Thank you 👍@sufiyan

[@ashok_kumar890]

Thnk u sir

[@maheshjadhav7367]

Thank you sir

[@interviewhappyrawat]

So nice of you @ Mahesh

[@pbbhosale9]

Superb video

[@interviewhappyrawat]

Thank you so much 😀

[@alihamza-il8dq]

Make video on python

[@JITENDRASINGH-fj5uc]

I have angular interview .. all .net concepts clear your hindi video so please sir 🙏 help me

[@SanjayKumar-qt3xc]

Please share ms sql dba questions

[@omkarbelpatre5]

Sir practical video for SQL sir

[@honeypatel9054]

Happy sir please ado.net interview questions per video banayye please

[@JITENDRASINGH-fj5uc]

Can you please upload angular in hindi please sir 🙏

[@SrivaniPatibanda-PositiviTEA]

I did not understand nth highest salary of an employee. Because top one among those is 10000. But our result is 6000 . Is that not wrong ? please correct me if my understanding is not right.

[@soundarrajan8182]

Dear Interview Happy,
Kindly post your all videos only ENGLISH!

[@pragyashakya6186]

want 2nd part

[@smita1993]

Interview happy...ak channel hain...uska copy lag raha hai

[@Saurabh_xotic]

dono happy sir ke he h

[@engineersINnight]

very nice

[@interviewhappyrawat]

You’re most welcome@abhaymalviya9482

[@TechnoMusicGaming]

Hi Anurag/Happy,
Please Share your LinkedIn, I would be more happy to connect you on LinkedIn

[@arvindraghav1]

Please make videos on design patterns.

[@SonuShwetaComedy]

Awesome

[@hemantkumar7131]

thank you sir

[@interviewhappyrawat]

Most welcome @hemant

[@prajaktawaidande8789]

Thank you Sir

[@interviewhappyrawat]

Most welcome

[@jitendrapatidar2605]

Awesome