🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 8:

List Unique Customers

SQL Server 2022
 The Customer table contains duplicate customer records. List unique records with FirstName, MiddleName, LastName, EmailAddress, and Phone, sorted by first and last name.
Expected result Columns: 5 · Rows: 440
FirstName MiddleName LastName EmailAddress Phone

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query