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

Mention the different types of replication in sql server.

1068

What the different types of Replication and why are they used?

1127

What do you mean by sql server agent?

1039

What is an indexing strategy?

1063

What is sql collation?

1266

Explain the difference between cross join and full outer join?

1029

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2821

What is the use of partition by in sql server?

968

when would you go for denormalization? : Sql server database administration

909

What are the different SQL Server Versions you have worked on?

1057

What is ssl in sql server?

1131

What are the advantages of mirroring?

1041

How to delete an existing database user?

1077

why would you call update statistics? : Sql server database administration

1156

How do you Implement SSIS Packages in your Project?

1982