select DISTINCT sal from emp;

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 / priya

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

Answer Posted / priya

select DISTINCT sal from emp;

Is This Answer Correct ?

8 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is a view? : Sql dba

1092

Why schema is used in sql?

1047

What is data control language?

990

What are %type and %rowtype for?

1052

What is sql select statement?

1031

Can ddl statements be used in pl/sql?

1143

how to convert character strings to dates? : Sql dba

1060

What is the life of an sql statement?

1024

What is sql trigger example?

1061

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2170

what is the difference between delete and truncate statement in sql? : Sql dba

1245

what is the command used to fetch first 5 characters of the string? : Sql dba

1638

What is difference between sql and excel?

1092

Explain the insert into statements in sql?

1005

Can cursors be part of a trigger body?

1641