SG Analytics Database Admin Interview Questions and Answers

To delete duplicate records from a table, we can use the DISTINCT keyword or GROUP BY clause in SQL.

• Use the DISTINCT keyword to select unique records from the table.

• Use the GROUP BY clause to group the records by a specific column and select only the distinct groups.

• Use the HAVING clause to filter out groups with more than one record.

• Create a temporary table with distinct records and then delete the original table and ...read more