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
24017 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 do I view a table in sql?

1040

what are date and time data types in mysql? : Sql dba

1021

Explain what is rdbms?

1085

what is a cursor? : Sql dba

1065

What are the different set operators available in sql?

1078

Explain clause in sql?

1071

How does one use sql*loader to load images, sound clips and documents? : aql loader

1233

Is it possible to update views?

1006

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1008

how to use case expression? : Sql dba

1078

How do I run sql?

1254

What is character functions?

1114

What is difference between function and trigger?

1109

What is the best partition size for windows 10?

1049

What are sql triggers used for?

1035