Varshini S
asked on
Need help for SQL query
I have the following table
EmployeeCode City
AA1 XXX
AA1 NN
BB1 XXX
BB1 NN
CC1 XXX
DD1 NN
in the above table - I need to delete employee has more than one record and delete only city='NN'
EmployeeCode City
AA1 XXX
AA1 NN
BB1 XXX
BB1 NN
CC1 XXX
DD1 NN
in the above table - I need to delete employee has more than one record and delete only city='NN'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am sorry. I need to SN=0 not >1 . Am I correct ?