CareerCup

Create another table Table2 with same structure as Table1. Then copy distinct rows from Table 1 into Table 2 -
INSERT INTO Table2 SELECT DISTINCT * FROM Table1;

SELECT SUM(LEN(STRING)-LEN(REPLACE(STRING,'A',''))) FROM TABLE

With Dele as
(
select
Row_Number() over (Partition by FirstName, LastName, Occupation, Age, ZipCode order by id) as RN,
*
From [a].[Person])

Delete from Dele
where RN>1

DELETE FROM table_name A WHERE ROWID > (
  SELECT min(rowid) FROM table_name B
      WHERE A.key_values = B.key_values);

select distinct <columnname> from tablename;

DELETE
FROM EMPLOYEE
WHERE ROWID NOT IN
(SELECT MAX(ROWID) FROM EMPLOYEE GROUP BY EMP_ID
);

select sum(regexp_count(first_name,'i')) 
from
(
select first_name,count(1) from emp
group by first_name 
having count(1) =1
);