Select Sal From Emp Group By Sal

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

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

Answer Posted / muthukumar

Select Sal From Emp
Group By Sal

Is This Answer Correct ?

3 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is spool?

993

what is the difference between char_length and length? : Sql dba

993

What is left inner join in sql?

986

how to get help information from the server? : Sql dba

878

What does where 1/2 mean in sql?

1012

What are stored procedures in mysql?

971

How do I edit a stored procedure?

950

What is a full join sql?

983

What is an oracle stored procedure?

990

What is a stored procedure in sql with example?

1058

How do I audit the sql sent to the server?

958

How to run pl/sql statements in sql*plus?

1024

What are aggregate and scalar functions?

978

Is trigger a stored procedure?

887

What is sql query limit?

914