Select sal form from my_table group by sal having count(*)>1

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 / sandeep sudunagunta

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

Answer Posted / sandeep sudunagunta

Select sal form from my_table group by sal having count(*)>1

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is embedded sql what are its advantages?

962

Why are cursors used?

1058

What is cold data?

897

How can I tell if sql is running?

998

What are the different datatypes available in PL/SQL?

1029

how to get a list of columns in an existing table? : Sql dba

916

what is the difference between primary key and unique key? : Sql dba

972

Is there a 64 bit version of ssms?

896

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

944

What is the difference between null value, zero, and blank space?

1139

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

934

Explian rowid, rownum? What are the psoducolumns we have?

945

What are the possible values for the boolean data field?

902

How can we find duplicate records in a table?

894

what are all the different types of indexes? : Sql dba

998