I assume You have Northwind Database.
I will be using The Employee Table.
As Show in the figure there are 6 Selected cells which are the Duplicates( Just assume it)
I want to find this number ( i mean 6.)
The query for the above is:
I will be using The Employee Table.
As Show in the figure there are 6 Selected cells which are the Duplicates( Just assume it)
I want to find this number ( i mean 6.)
The query for the above is:
SELECT Title
, COUNT(Title) AS NumOccurrences
FROM dbo.Employees
GROUP BY Title
HAVING ( COUNT(Title) > 1 )
SELECT *
FROM dbo.Employees
0 comments:
Post a Comment