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
23228 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 are some emotional triggers?

928

define data blocks ? : Sql dba

930

Which is better join or inner query?

960

What is the clause we need to add in function body to return variable?

965

What is field delimiter?

989

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

956

Which function is used to return remainder in a division operator in sql?

1074

Does oracle roll back the transaction on an error?

960

explain primary keys and auto increment fields in mysql : sql dba

899

What are basic techniques of indexing?

1320

Show code of a cursor for loop.

1000

What are sql functions? Describe the different types of sql functions?

1057

How to install oracle sql developer?

984

What is the difference between delete, truncate and drop command?

1060

What are the possible values that can be stored in a boolean data field?

947