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
10723 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 pl sql in oracle?

990

how to include comments in sql statements? : Sql dba

910

How to revise and re-run the last sql command?

1099

What is sequence in sql?

938

Explain the difference between sql and mysql.

1001

what is sub-query? : Transact sql

1039

How many types of cursors are available in pl/sql?

1042

what is table? : Sql dba

989

What is implicit cursor in pl sql?

1027

What is a left inner join?

946

What is the use of triggers?

979

How do I save the results of sql query in a file?

926

What is sql partition function?

1117

What is the syntax and use of the coalesce function?

1097

Can we insert in view in sql?

1002