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.
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😀😀
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.
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;
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
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
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.
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 .
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.
Nice video , thank you sir.
Love from chamoli (uttarakhand) !!
Amazing boss.....
Very easily to crack interview.
Thank you so much...😊
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😀😀
thanks for this excellent video of learning new things. thank you once again Happy Sir....
You are most welcome
You are awesome sir explanation way is very awesome.
Thanks a ton
Sir normalisation, view, temp table, transaction pr bhi ak video bnao please
Love you sir what an explanations of all your videos on interview. Love from Odisha...
nice video sir
API aur webservice me difference ka ek example bataye please
Thanks for very detailed session
My pleasure! @shoukatmalik6013
Thank you sir....save my time for interview preparation
Most welcome
one more sql questons and answeers session is requied so pls make it
osm and simple explanation wowwwww big respect
Amazing Video 👍👌
Thank you 👍@sufiyan
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.
Sir , do you have sql server Vedio for dba interview
As always.....just WAOOO😊
sir its very helpful in interview , thanks
Glad to hear that
Please make videos on design patterns.
Happy sir please ado.net interview questions per video banayye please
Thank u so much sir is very helpful 👏
Most welcome
Only one null value allowed in Unique constraint please elaborate as in table multiple null allowed with unique constraint.
Could you please share Azure interview questions videos or links
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;
Superb video
Thank you so much 😀
Please share ms sql dba questions
Great
Sir practical video for SQL sir
Thank you so much sir
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
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
Make video on python
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
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.
Thank you sir
So nice of you @ Mahesh
Sir please provide list of question in pdf file
Dear Interview Happy,
Kindly post your all videos only ENGLISH!
Thnk u sir
Awesome
want 2nd part
Interview happy...ak channel hain...uska copy lag raha hai
dono happy sir ke he h
Pdf??
very nice
You’re most welcome@abhaymalviya9482
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 .
Hi Anurag/Happy,
Please Share your LinkedIn, I would be more happy to connect you on LinkedIn
Please make videos on design patterns.
thank you sir
Most welcome @hemant
Fabulous
Awesome
Thanks sir
Thank you Sir
Most welcome
Awesome