You administer a Microsoft SQL Server 2012 database that includes a table named Products. The Products table has columns named Productld, ProductName, and CreatedDateTime. The table contains a unique constraint on the combination of ProductName and CreatedDateTime. You need to modify the Products table to meet the following requirements:

Remove all duplicates of the Products table based on the ProductName

column.

Retain only the newest Products row.

Which Transact-SQL query should you use?

Question

You administer a Microsoft SQL Server 2012 database that includes a table named Products. The Products table has columns named Productld, ProductName, and CreatedDateTime. The table contains a unique constraint on the combination of ProductName and CreatedDateTime. You need to modify the Products table to meet the following requirements:

Remove all duplicates of the Products table based on the ProductName

column.

Retain only the newest Products row.

Which Transact-SQL query should you use?

Accepted Answer

B. WITH CTEDupRecords

Answer

A. WITH CTEDupRecords

Answer

C. WITH CTEDupRecords

Answer

D. WITH CTEDupRecords

You administer a Microsoft SQL Server 2012 database that includes a table named Products. The Products table has columns named Productld, ProductName, and CreatedDateTime. The table contains a…

Question

Options

How the community answered

Community Discussion