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

What is raw datatype in sql?

1024

What is clustered index sql?

971

What is primary key and unique key?

1096

Can pl sql procedure have a return statement?

999

What is a data definition language?

1078

Explain the insert into statements in sql?

981

What is the maximum rows in csv?

910

What are aggregate and scalar functions?

1002

How does cross join work?

917

What is pivot query?

1055

What is the difference between a subquery and a join?

1071

How do you truncate?

891

What is pivot table in sql?

1081

What are some emotional triggers?

962

What do you understand by pl/sql records?

998