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
10718 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 the difference between microsoft sql and mysql?

919

Does access use sql?

965

What does pl sql stand for?

1062

How do I save a stored procedure?

945

What are pl/sql cursors?

986

What jobs use sql?

924

What are primary key and foreign key and how they work?

926

What is scope of pl sql developer in future?

947

How do you go back in sql?

939

What is row_number () in sql?

929

What is the difference between sql and mysql?

1050

What is a full join sql?

980

What is a left join?

885

Explain foreign key in sql?

968

what is oracle database ? : Sql dba

966