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

Is left join inner or outer?

1014

What is trigger with example?

1100

Can ddl statements be used in pl/sql?

1143

What are stored procedures used for?

1002

Explain the savepoint statement.

1097

What is fmtonly in sql?

1085

Can you have more than one trigger on a table?

1003

How exception handling is done in advance pl/sql?

981

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

How can we make an if statement within a select statement?

1013

What is function and procedure in pl sql?

1044

What is input buffer in sql*plus?

1222

What mean sql?

1010

What are sql queries used for?

1023

which types of join is used in sql widely? : Sql dba

982