SQL Grouping Example

 SELECT DISTINCT count(pv.CandidateId)

,Month(pv.DatePaid)



FROM dfadfasdf AS pv


INNER JOIN dfadfasdf.Candidate AS cd ON cd.CandidateID = pv.CandidateId

INNER JOIN dfadfasdf.Province AS p ON p.ID = cd.ProvinceID 


WHERE Year(DatePaid) = '2022'

AND Month(DatePaid) IN ('01', '02', '03')


GROUP BY Month(pv.DatePaid)

ORDER BY count(pv.CandidateId)



SELECT DISTINCT count(pv.CandidateId) AS "Candidate Count"

,cd.ProvinceID

,Month(pv.DatePaid) AS "Month"




FROM dfadfasdf.dbo.PayrollVIPFile AS pv


INNER JOIN dfadfasdf.dbo.Candidate AS cd ON cd.CandidateID = pv.CandidateId

INNER JOIN dfadfasdf.dbo.Province AS p ON p.ID = cd.ProvinceID 


WHERE Year(DatePaid) = '2021'

AND Month(DatePaid) IN ('01', '02', '03')


GROUP BY cd.ProvinceID, Month(pv.DatePaid)


ORDER BY count(pv.CandidateId), Month(pv.DatePaid)


Comments

Post a Comment

Popular posts from this blog

Time Example

 SELECT distinct td.[CandidateID] ,pc.Description AS Province ,Year(td.Start) ,Day(td.Start) ,cast(td.[Start] as time) [time] ,cast(td.[End] as time) [time]   FROM [hjklhj].[dbo].[TimesheetDetail] AS td      INNER JOIN [jkljkh].[dbo].[Candidate] AS cd on td.CandidateID = cd.CandidateID   INNER JOIN [hjlhhhj].[dbo].[Province] AS pc on cd.ProvinceID = pc.Id   WHERE pc.Description = 'CB070000-CPT'    AND Year(Start) = '2021'   AND Month(Start) = '01'
Read more

SET IDENTITY_INSERT

Image
  SET IDENTITY_INSERT (Transact-SQL) Article 01/30/2021 2 minutes to read 14 contributors Applies to:   SQL Server (all supported versions)  Azure SQL Database  Azure SQL Managed Instance  Azure Synapse Analytics Allows explicit values to be inserted into the identity column of a table.   Transact-SQL Syntax Conventions Syntax syntaxsql SET IDENTITY _ INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }
Read more