How to E liminates Duplicate Rows? The “ DISTINCT ” returns only distinct value and DISTINCT “ eliminates duplicate records ” from the result set. Also “ operates ” only on a single column and not for multiple columns . The “ DISTINCT ” key can be used with aggregates like COUNT , AVG , and MAX , so on.. Stayed Informed - 37 Best SQL Server Interview Questions and Answers Syntax :- SELECT DISTINCT ColumnName, ColumnName FROM TableName OR -- USING COUNT AGGREGATE SELECT COUNT ( DISTINCT ColumnName) FROM TableName Examples:- SELECT DISTINCT CountryName FROM Countries ORDER BY CountryName Result:- CountryName CountryCode --------------------------- India IN Nepal NP Rasia RA USA US Stayed Informed - SQL Server Query and Examples I hope you are enjoying with this post! Please share with you friends. Thank you!!
Angular, React, JavaScript, Java, PHP, SQL, C#, Vue, NodeJs, TypeScript and Interview Questions Answers