Write a SQL query to find all duplicate emails in a table named [email protected]@[email protected] example, your query should return the following for the above table:[email protected]Note: All emails are in lowercase.Optionsselect Email from Person group by Email having count(Email) <= 1;select Email group by Email having count(Email) > 1;select Email from Person group by Email having count(Email) > 1;select Email from Person group by Email having count(Email) ;

Select all the correct answersWrite a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest [email protected]@[email protected] is the primary key column for this table.For example, after running your query, the above Person table should have the following rows:[email protected]@example.comNote: Your output is the whole Person table after executing your sql. Use delete statement.Optionsdelete p.* from Person as p, ( select Email, min(Id) as minId from Person where having count(*) > 1) as q where p.Email = q.Email and Id > q.minId;delete p1 from Person as p1, Person as p2where p1.Email = p2.Email and p1.Id > p2.Id;delete p.* from Person as p, ( select Email, min(Id) as minId from Person group by Email having count(*) > 1) as q where p.Email = q.Email and Id > q.minId;delete p1 from Person as p1, Person as p2where p1.Email != p2.Email and p1.Id <= p2.Id;Finish ClearPrev

Write a query to display the number of buildings having an email_address. Give an alias name as 'count_of_buildings_with_email'.Note:1. Display only the count of buildings having an email_address from building table.2. Specify the alias name without any mistake.3. Specify condition and retrieve the correct number of rows.(condition need to be specified on email_address column. If email_address is not null then it must be counted)3. Compare your executed result with the sample output given below.

Write a query to display the number of buildings having an email_address. Give an alias name as 'count_of_buildings_with_email'.Note:1. Display only the count of buildings having an email_address from building table.2. Specify the alias name without any mistake.3. Specify condition and retrieve the correct number of rows.(condition need to be specified on email_address column. If email_address is not null then it must be counted)3. Compare your executed result with the sample output given below.Sample Output:

How can you remove duplicate rows from a result set in SQL?

DISTINCT can be used for removing duplicate tuples in the query result in SQL