Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 13 Answers
- 23215 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
How do I add a primary key to a table?
Define join and name different types of joins?
what are the differences between binary and varbinary? : Sql dba
What is the difference between the implicit and explicit cursors?
What company owns postgresql?
explain advantages of myisam over innodb? : Sql dba
What is file based approach?
What is mutating table error?
how to use myisamchk to check or repair myisam tables? : Sql dba
What does where 1 1 mean in sql?
How do you copy a table in sql?
What is the primary use of normalization?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What are the sql commands?
What is string join?
