SQL Server: How to print original & duplicate data

Question

Below sql print which data has duplicate but i want the output bit different way

I want to print the actual data and duplicate too. in the below sql here data is group by masterid,SectionID, LineItemID,PeriodID but their value field could have different data.

so tell me how could i print actual & duplicate too in same result one after one. if my question not clear then please let me know so i will try to elaborate it with example. thanks

WITH CTE AS
(
    SELECT *,ROW_NUMBER() OVER (PARTITION BY masterid,SectionID, LineItemID,PeriodID ORDER BY masterid,SectionID, LineItemID,PeriodID) AS RN
    FROM tblTicker_Bogey 
)

Select * from CTE where RN>1

Answer 1

Try this query:

SELECT *
FROM tblTicker_Bogey 
ORDER BY masterid,SectionID, LineItemID,PeriodID

Answer 2

If I understand it correctly, this is what you're after:

WITH CTE AS    (
      SELECT *, COUNT() OVER (PARTITION BY masterid,SectionID, LineItemID,PeriodID) AS cnt
      FROM tblTicker_Bogey 
)
Select * from CTE where cnt>1