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
- 19783 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / narasimha
select distinct(sal) sal from salex;
| Is This Answer Correct ? | 35 Yes | 22 No |
Post New Answer View All Answers
What are the different operators available in sql?
What's the difference between inner join and left join?
What is the difference between left and left outer join?
How can you load multi line records? : aql loader
What are the advantages of sql?
How do you bind variables in pl sql?
Why is theta join required?
What are expressions?
Why do we need pl sql?
What is the starting oracle error number?
What are the triggers associated with image items?
What is the difference between a primary key and a unique key?
What does 0 mean in sql?
What is scalar function in sql?
what is sql profiler? : Sql dba
