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 only how should u
write query?
- 9 Answers
- 11337 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / annalakshmi.s
select distinct(salary) from tablename
Example:
employee is the table name
salary is the column name means
select distinct(salary) from employee
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between local and global temporary table?
What is meant by truncate in sql?
how mysql optimizes distinct? : Sql dba
what is 'trigger' in sql? : Sql dba
Explain character-manipulation functions?
what are the disadvantages of mysql? : Sql dba
How long will it take to learn pl sql?
Is clustered index a primary key?
How do I make my sql query run faster?
Is sql better than access?
Is sqlite thread safe?
Why do we use joins?
Can we use ddl statements in stored procedure sql server?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
