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
- 19940 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
Is it important to partition hard disk?
What are the features of pl sql?
What is the purpose of the sql select top clause?
What operating systems are supported by oracle sql developer?
What are the benefits of stored procedures?
Why do we use %rowtype & %type in plsql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is a recursive stored procedure?
how to calculate expressions with sql statements? : Sql dba
What is java sql connection?
What is loop in pl sql?
What is the usage of sql functions?
What is normalization? How many normalization forms are there?
What is normalisation and its types?
how can we repair a mysql table? : Sql dba
