Interested to Buy Any Domain ? << Click Here >> for more details...
how do you count the duplicate records in a table
- 10 Answers
- 19175 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / satheesh
SELECT COUNT(*)
FROM TABLE A
WHERE ROWID NOT IN (SELECT MAX(ROWID)
FROM TABLE B
WHERE A.COL1 = B.COL1);--UNIQUE COLUMN
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain the difference between myisam static and myisam dynamic. : Sql dba
What do you mean by “trigger” in sql?
what is view? : Sql dba
Is sql difficult?
How do you delete data from a table?
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
What is the maximum number of rows in sql table?
What is not in sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is 19 null in sql?
What is package in pl sql with an examples?
How is pl sql different from sql?
How do you determine the current isolation level? : Transact sql
How would you convert date into julian date format?
What jobs use sql?
