SQL Server query interview question and answer | Sql Server Interview Question for experience

SQL Server latest query related interview questions and answers

Query:
select custid,avg(diff) as avg_sale from
(
Select custid,lag(sales,1) over (partition by custid order by orderdate desc)-sales as diff
FROM [INTERVIEW].[DBO].[AVG_OF_DIFF_TBL]
) as a
group by custid

For Quiz-

Find Us On FaceBook-

[Raj-phpy]

Hi Sushil,
Great tutorial I always learn something new from your videos.

[somasreebiswas]

Please provide the input here, i was not able to find it on fb.

[djshaikhofficial]

Dear sir i have 1 query can you solve it in sql ? That question asked by interviewer and i wasn't able to solve that.

[mrimranaltaf]

hi sir, kindly advise how I can overcome latency between always on primary and secondary nodes, because when I commit insert record on the primary node and same time I read data from secondary node so data has been not available.

Kindly advise the solution to reduce or eliminate latency between always-on nodes