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

What is program debugging?

1229

how to create a new table by selecting rows from another table in mysql? : Sql dba

1076

How do I run a program in pl sql?

994

Why procedure is used in sql?

1030

Is join same as left join?

1027

What are dml commands?

1014

How do you remove duplicates without using distinct in sql?

969

How can you view the errors encountered in a trigger?

953

Is left join inner or outer by default?

1014

What is the maximum rows in csv?

918

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1201

How do I view a table in sql?

998

what is the difference between truncate and delete statement? : Transact sql

1053

write an sql query to find names of employee start with 'a'? : Sql dba

1020

how to present a past time in hours, minutes and seconds? : Sql dba

1002