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

How to create stored procedures with parameters in ms sql server?

1079

How to use subqueries with the in operators in ms sql server?

1074

Ways to improve the performance of a SQL Azure Database?

125

Do you know how to implement service broker?

928

Tell me what is de-normalization and what are some of the examples of it?

1050

How do use Having,Group by,Group function in SQL?

1745

What are the filtered indexes?

1040

Do you know what are the reporting services components?

976

Why use identity in sql server?

1106

Explain the various types of concurrency problem?

1195

How to throw custom exception in Stored Procedure?

1044

What are the new scripting capabilities of ssms? : sql server management studio

1067

what is raid? : Sql server database administration

1041

What is the data tier application?

169

How to write an inner join with the where clause in ms sql server?

1091