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
11079 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 data control language?

991

what is the difference between a local and a global temporary table? : Sql dba

1073

Why procedure is used in sql?

1037

What is a sql driver?

1000

Can we write dml inside a function in sql server?

953

Is stored procedure faster than query?

969

How to pronounce postgresql?

1059

how to rename an existing table in mysql? : Sql dba

1064

What are the different dcl commands in sql?

1174

Which one is faster ienumerable or iqueryable?

934

What are %type and %rowtype for?

1052

Define concurrency control. : Transact sql

1192

Can we group by two columns in sql?

997

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1209

What do you understand by pl/sql cursors?

1088