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

How do you write an inner join query?

943

Is not equal in sql?

1008

What is the difference between nested table and varray?

996

Does db2 use sql?

937

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

1000

What are functions in sql?

950

discuss about myisam key cache. : Sql dba

1014

What does varchar include?

943

What is bitemporal narrowing?

1298

what is 'mysqlimport'? : Sql dba

1041

what are the t string functions available in tsql? : Transact sql

1002

What is minus?

986

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1035

What is nosql vs sql?

1172

Write the command to remove all players named sachin from the players table.

1175