select distinct(SAL) as SAL from table

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 / yaswanth

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

Answer Posted / yaswanth

select distinct(SAL) as SAL from table_name;

Is This Answer Correct ?

17 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql better than access?

962

What is memory optimized table?

985

what is the use of double ampersand (&&) in sql queries?

1115

What does <> sql mean?

987

What is compute?

1011

What found sql?

894

How can we store rows in PL/SQL using array?

1159

What is the difference between nested table and varray?

942

Is pl sql and postgresql same?

1053

What is the max nvarchar size?

897

what is 'mysqladmin' in mysql? : Sql dba

972

How do I pipe the output of one isql to another?

944

What is before trigger?

946

What is the trigger in sql?

903

What is the mutating table and constraining table?

967