选择单个和重复行并返回多个列

I'm currently working with my database in SQL Server. I have a table with 23 fields and it has single and duplicate rows. How can I select both of them without having any duplicate data. I have try this query:I'm currently working with my database in SQL S