how to delete duplicate rows from table in sql server

Answer Posted / vignesh chandrasekaran

select Distinct column name from Table Name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about merge replications?

591


What are partitioned views and distributed partitioned views?

600


How exceptions can be handled in sql server programming?

543


query processing

1734


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

525






What are the 3 types of schema?

597


What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

548


Can we use where clause with group by?

514


Explain difference between control flow and data flow?

524


Write a SQL queries on Self Join and Inner Join.

615


How do you test your database? : sql server database administration

521


Distinguish between commit and rollback?

539


What is the purpose of object explorer and its features? : sql server management studio

592


Does windows server 2016 come with sql server?

497


What are the filtered indexes?

594