Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1 6
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Apr
3
comment Select query having count and variable
,Thank you Sooo much. This Is the one I exactly require.
Apr
3
comment Select query having count and variable
I'm so sorry that I'm not able to explain my problem in the way you understand. @JNK is Right that I'm using 1 as RefID in the Parameter
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