Create DB user and assign role to user

-------------------------------------
-------DB User ----------------------

--sp_addlogin Creates a new SQL Server login that allows a user to connect to an instance of SQL Server by using SQL Server authentication.
-- EXEC sp_addlogin 'login name', 'Password', 'Database'
EXEC sp_addlogin 'dentry','dentry','doris'

----online Database Name------
use doris

--sp_adduser Adds a new user to the current database.
--EXEC sp_adduser 'login name', 'User name'
EXEC sp_adduser 'dentry','dentry'

--sp_addrolemember Adds a database user, database role, Windows login, or Windows group to a database role in the current database.
--EXEC sp_addrolemember 'DB role', 'User'
EXEC sp_addrolemember 'operator','dentry'

print 'user data entry created successfully'



--add new role in db

EXEC sp_addrole 'Managers'

SQL Select count greater then 3

Select all those Name From table whose count is 3 in SQL Server

select t.name from (select name,count(name) as namecount from table1 group by name) t where t.namecount=3

table1
Name (column)
a
a
a
a
b
b
b
v
v
v
g
hg
g
g
k
k

o/p
Name
a
b
v
g