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

How to fetch alternate records from a table?

1253

What is oracle sql called?

930

What are the differences between in and exists clause?

1121

What are the two virtual tables available at the time of database trigger execution?

1232

Is t sql a programming language?

1073

How do I truncate a word?

1100

what are local and global variables and their differences? : Sql dba

1082

What is a full join?

997

How to convert comma separated string to array in pl/sql?

1195

Explain autonomous transaction.

1163

What is pl sql block structure?

1045

What is union and union all keyword in sql and what are their differences?

1111

what is uncommittable transactions? : Transact sql

1000

explain about mysql and its features. : Sql dba

1021

What are the constraints available in sql?

1055