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
11070 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 types of records?

988

How do I view stored procedures?

973

how to decrement dates by 1 in mysql? : Sql dba

1017

What is a sql statement?

955

What is write ahead logging in sql server?

1050

What do you think about pl/sql?

1029

Can we use join in subquery?

1095

What do you mean by query optimization?

1002

what is cursor. write example of it. What are the attributes of cursor.

1388

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

957

What is record type in pl sql?

991

What is clustered index in sql?

1051

Are stored procedures faster than queries?

944

What is pl sql quora?

1155

How to read/write files from pl/sql?

1035