SQL Server Top 30 Interview Questions (in HINDI)

Awesome

Sir , do you have sql server Vedio for dba interview

Amazing Video 👍👌

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

As always.....just WAOOO😊

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;

thank you sir

Awesome

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

Thanks for very detailed session

Could you please share Azure interview questions videos or links

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 [email protected]

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/[email protected]


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

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

very nice

Great

Thank you sir

Please make videos on design patterns.

Please make videos on design patterns.

Can you please upload angular in hindi please sir 🙏

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