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
10970 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 are the non-standard sql commands supported by 'mysql'? : Sql dba

1094

How to combine two stored procedures in sql?

1197

Is it possible to create startup or shutdown trigger for on-schema?

1009

How long does it take to learn pl sql?

1044

What is meant by user defined function?

1026

Mention what are different methods to trace the pl/sql code?

1177

Can we connect to postgresql using sql developer?

981

Explain locks? : Transact sql

987

What is use of package in pl sql?

992

Sql technical questions

1250

What is AUTH_ID and AUTH_USER in pl/sql ?

2169

what are aggregate and scalar functions? : Sql dba

1038

What is the current version of postgresql?

1043

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1073

How to load data with sql*loader?

1032