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

What is sql mysql pl sql oracle?

1064

What does partition by mean in sql?

955

what is a trigger in mysql? : Sql dba

1139

What is raw datatype in sql?

1042

Can a commit statement be executed as part of a trigger?

1046

What is primary key and unique key?

1112

What is sql partition?

1101

Define a temp table?

1016

How will you distinguish a global variable with a local variable in pl/sql?

1148

What is a scalar value in sql?

1069

How does sql developer connect to oracle database?

994

What happens when a trigger is associated to a view?

904

What is full join?

947

What is pl sql block in dbms?

997

What is cte?

970