101 reputation
5
bio website maabookings.com
location Hyderabad, India
age 25
visits member for 1 year, 11 months
seen Jul 11 at 10:42

I'm a .Net Developer Working in Hyderabad. I have Knowledge on .NET, SQL SERVER, and other .Net Extensions


Apr
3
comment Select query having count and variable
Once check the First Table. In that the RefID contains Value-2 1 time. The Value-2 is the Serial No of the same Table and since SNo 5 is not Present as the RefID in the First Table the Cnt is 0 in the output Table. In the Output, the cnt column is the count of the RefID s. ie If there is a SNo 1 in the Output, The Cnt would be 5. Because, since the SNo 5 is Used 5 times as RefID in the First Table. Ok?
Apr
3
comment Select query having count and variable
Because the SNo 5 is not there in RefID column. and Since Sno 2 is referenced 1 time in RefID, the Cnt of Sno 2 in Output is 1.
Apr
3
asked Select query having count and variable
Dec
17
awarded  Supporter
Oct
11
awarded  Autobiographer