write a query to remove duplicate records without using primary key column?

Answer Posted / 312

351

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between Sql server reporting services and Crystal reports?

124


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

88


Explain what are the restrictions that views have to follow? : SQL Server Architecture

597


How do you create a clustered index?

532


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

644






What is the syntax for encrypting a column in SQL Server?

559


What are the characteristics of modern DBMS?

626


What is the main difference between ‘between’ and ‘in’ condition operators?

591


Is there any difference between the primary key and unique key?

574


What is pivot and unpivot?

644


Differentiate between a primary key and a unique key.

604


Does a server store data?

504


Is sql server a database?

539


Difference between aggregate functions of sql?

654


How do we synchronize On-Premise SQL server with SQL Azure?

100