select distinct(sal) from my

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 / mohannad amarneh

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

Answer Posted / mohannad amarneh

select distinct(sal) from my_table;

Is This Answer Correct ?

8 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is pl sql still used?

977

Can you have more than one key in a database?

937

How run sql*plus commands that are stored in a local file?

1061

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1006

What is cross join sql?

917

How many postgresql users are there, worldwide?

1061

How do I remove sql plus from windows 10?

1101

What type of database is cloud sql?

1101

what is an alias command? : Sql dba

1115

What is substitution variable in pl sql?

1044

Is primary key clustered index?

949

What is relationship? How many types of relationship are there?

1183

Which software is used for pl sql programming?

990

what is a constraint? : Sql dba

1172

What is the difference between function and procedure in pl/sql?

1086