We can simply remove duplicate from table 1. Using CTE 2. Using Group by

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

Question Posted / virendra maurya

Answer Posted / virendra maurya

We can simply remove duplicate from table
1. Using CTE
2. Using Group by
3. Using Rank function

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are the different types of replication you can set up in sql server? : Sql server database administration

745

What is the difference between count () and rowcount ()?

706

Explain what is “asynchronous” communication in sql server service broker?

666

How to find related tables in sql server?

685

Tell me what is the stuff and how does it differ from the replace function?

719

How to drop an existing schema in ms sql server?

755

What is normalization and its types?

750

Mention the different authentication modes in sql server.

700

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

933

What are triggers in ms sql server?

796

Which tools are available to manage SQL Azure databases and servers?

107

How can you check the level of fragmentation on a table?

774

What is triggers in ms sql server?

804

Define model database?

741

How can I create a report based on a query? : sql server management studio

759