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
23666 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 can I get the number of records affected by a stored procedure?

1059

Why trigger is used in sql?

966

What are all the different types of indexes?

1147

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1056

What is the difference between partitioning and sharding?

1004

what are numeric data types? : Sql dba

1060

What are tables and fields?

1029

describe mysql connection using mysql binary. : Sql dba

1064

What is nvarchar max in sql?

1010

How does pl sql work?

957

How do I pipe the output of one isql to another?

1002

What are all different types of collation sensitivity?

1027

what is a foreign key ? : Sql dba

1079

What are the differences between in and exists clause?

1111

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1342