scenerio is:
whenever user tries to change his password, his new password is sent to database and now i have a query which retrieves all the last changed password by this user with query (in my case only 5 matters)
Expand|Select|Wrap|Line Numbers
- select top 5 columnname from tablename where id=@id.
hope i am clear.
what i have tried id:
Expand|Select|Wrap|Line Numbers
- select count(*) from PwdHistory where @Suppliedpwd
- in (select top 5 columnname from PwdHistory where (UserId=@userid))
any help will be appreciated