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

How to rename a table?

997

What is Collation Sensitivity ? What are the various type ?

937

What are procedures used for?

966

Is sql difficult?

1141

What is synonyms?

1038

What is sp_helptext?

1051

List the different type of joins?

1055

What is sql injection owasp?

1037

Write a sql select query that only returns each name only once from a table?

992

How do you explain an index number?

1079

What are user defined functions?

992

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7265

What is sql dialect?

1094

Why left join is used in sql?

958

Does pl sql work in mysql?

950