select n from (select row_number()over (partition by n order by n) r,n fro

one of the column in my table contains the data like
SAL
----
1000
1000
2000
3000
3000

So my requirement is i want output like
SAL
---
1000
2000
3000

it mean i want to delete duplicate rows only how should u
write query?

Question Posted / hiya

9 Answers
11072 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / hiya

select n from (select row_number()over (partition by n order
by n) r,n from test group by n having count(*)>1)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dml with example?

1087

Why do we need unique key in a table?

957

which tcp/ip port does sql server run on? : Sql dba

1026

What is pl/sql language case sensitive?

1125

How do I pipe the output of one isql to another?

1004

What is crud stand for?

996

How do I install microsoft sql?

1050

what are the 'mysql' command line options? : Sql dba

1072

What is a call statement? Explain with an example.

1010

Why functions are used in sql?

990

What is trigger in pl sql?

1000

Is a table valued function object?

1017

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

how many columns can be used for creating index? : Sql dba

946

How do I copy a table in sql?

988