Hi, can any one help me giving the code to this query?
I have a Customer table which have duplicate rows. In that table
I. I want only unique rows.
2. I want only Duplicate rows ( if in Table unique rows exist, i don't want them to display)
You can create table as with data with a select query something like this:
select id,id1..... from your_table
qualify row_number() over(partition by id,id1..... order by id,id1.....)>1 or =1