select distinct(sal) sal from salex;

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 in the table
permanently and i want output in the above formatow should u
write query?

Question Posted / narasimha

13 Answers
24021 Views
Cap Gemini, TCS, I also Faced
E-Mail Answers

Answer Posted / narasimha

select distinct(sal) sal from salex;

Is This Answer Correct ?

35 Yes

22 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

State some properties of relational databases?

1115

What are different functions in sql?

998

What is the size of partition table?

1089

what is the difference between blob and text? : Sql dba

1063

What is multiple columns?

1118

What are the advantages of pl sql over sql?

1073

How many triggers can be applied on a table?

988

What is difference between sql and excel?

1179

what is meant by urlencode and urldocode? : Sql dba

1240

how to use like conditions? : Sql dba

1166

Is join an inner join?

1025

What can sql server reporting services do?

1164

which tcp/ip port does sql server run on? : Sql dba

1083

What is before and after trigger?

1010

What is query syntax?

1020