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
10988 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

Explain spool.

1166

Can primary key be changed?

896

What are local and global Indexes and where they are useful.

1433

What is autocommit sql?

972

Explain two easy sql optimizations.

997

What is a constraint? Tell me about its various levels.

1142

What is the usage of distinct keyword?

1051

Explain polymorphism in pl/sql.

1102

Why do we use cursors?

977

Is natural join same as inner join?

911

How do I know if I have sql express or standard?

1019

What is the starting oracle error number?

1039

What is the function that is used to transfer a pl/sql table log to a database table?

988

What is error ora-01000: maximum open cursors exceeded

1129

What are transaction and its controls?

1026