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?
Answer Posted / muthukumar
Select Sal From Emp
Group By Sal
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is the plv (pl/vision) package offers?
can sql servers linked to other servers like oracle? : Sql dba
Which is faster subquery or join?
Explain the select statement in sql?
Explain the difference between rename and alias?
How to run sql statements through the web interface?
What is the difference between between and in condition operators?
How do I view output in sql developer?
what is the command used to fetch first 5 characters of the string? : Sql dba
How to rename a table?
How do I kill a query in postgresql?
Why do we create views in sql?
Can we use delete in merge statement?
Can I join the same table twice?
How can we implement rollback or commit statement in a trigger?