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

Is sql sequential or random?

1028

Is sql microsoft?

1044

what is union, minus and interact commands? : Sql dba

1184

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

1381

What is memory optimized table?

1038

What is dense_rank?

933

How do you rename a table in sql?

1102

What is cursor in pl sql?

1114

What do you mean by table in sql?

986

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1055

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

Can we alter stored procedure?

984

How do you delete duplicates in sql query using rowid?

944

Differentiate between sga and pga.

1161

How do I remove duplicates in two columns?

1056