Select sal from emp 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 / manju

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

Answer Posted / manju

Select sal from emp group by sal having count(*)>=1

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sql profiler affect performance?

1047

How to run sql statements through the web interface?

1091

How to pronounce postgresql?

1096

What is self-join and what is the requirement of self-join?

1191

What is sql resultset?

1039

Explain how exception handling is done in advance pl/sql?

1045

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1286

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

1190

What is the usage of when clause in trigger?

1088

What is vector point function?

1094

What are different types of statements supported by sql?

1209

Does inner join return duplicate rows?

1039

What are the benefits of triggers?

1217

What is auto increment?

1044

What is use of package in pl sql?

1068