Declare @c_no int Set @c_no=1 select id1,count(id1) as cnt from tab1 group by id1 having count(id1)>@C_No Note: Result will come this way-> id1 cnt 101 2 103 2
I am Ajay Sinha Expertized in Sql Server and providing the consultancy Services in Database Maintainance , Crystal Report,Developed Application Software in VB,ASP.Net.
No comments:
Post a Comment