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

Can we rollback after truncate?

979

How would you convert date into julian date format?

946

What is an oracle stored procedure?

984

Explian rowid, rownum?

955

what are the different tables present in mysql? : Sql dba

922

What is the max nvarchar size?

896

Why do we use sql constraints?

1122

what is the different between now() and current_date()? : Sql dba

929

What is pl/sql language case sensitive?

1058

What is dense_rank in sql?

915

What is trigger point?

947

What is fmtonly in sql?

1001

What is sqlexception in java?

938

Is it possible to pass parameters to triggers?

1029

What does varchar include?

904