_:necc658c1695140f8a3a10f3158b5f656xb2
<http://schema.org/text>
"Hi PRAAdd pay parameter to where conditionRefer below queryDECLARE cash TABLE Id int smoney money syear char7 std char5 course int pay intINSERT INTO cash Id smoney syear std course pay VALUES 1 2000 N3920171839 N39A000139 1 0INSERT INTO cash Id smoney syear std course pay VALUES 2 1000 N3920171839 N39A000139 1 0INSERT INTO cash Id smoney syear std course pay VALUES 3 1000 N3920171839 N39A000239 1 0INSERT INTO cash Id smoney syear std course pay VALUES 4 1000 N3920171839 N39A000239 1 0INSERT INTO cash Id smoney syear std course pay VALUES 5 1000 N3920171839 N39A000339 1 0INSERT INTO cash Id smoney syear std course pay VALUES 6 2000 N3920171839 N39A000339 1 0INSERT INTO cash Id smoney syear std course pay VALUES 7 500 N3920171839 N39A000139 1 0INSERT INTO cash Id smoney syear"
<https://www.aspsnippets.com/questions/801207/Get-records-based-on-parameter-value-in-SQL-Server/>