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
11333 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 are its different types of dbms?

1053

discuss about myisam index statistics collection. : Sql dba

1003

What are the subsets of sql?

1195

how to enter numeric values as hex numbers? : Sql dba

1100

What is rtm stands for?

1173

What is meant by <> in sql?

1026

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1893

What is blind sql injection?

1164

How do I create a sql script?

1142

Can we use view in stored procedure?

954

Explain clause in sql?

1071

What is full join?

1019

Explain the structure of pl/sql in brief.

1138

What is difference between mysql and postgresql?

1233

Is and as keyword in pl sql?

1012