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

Difference between connected and disconnected database in .net with sql server?

1087

What is a transactions?

1033

What is the name of reporting services config file and what’s it’s used for?

146

What is index in an assignment?

946

How to select true false based on column value in sql server?

1011

Tell me the use of keyword with encryption. Create a store procedure with encryption?

997

What are the differences between lost updates and uncommitted dependencies?

1066

How to use clusters?

933

What do you think of this implementation? Can this be implemented better?

929

What are sparse columns?

1001

What is the purpose of linked server configuration in sql server?

1035

What are the steps to process a single select statement?

933

What is BCNF? How is it better than 2NF & 3NF?

1008

What triggers long term care?

1022

Explain the use of containers in ssis?

953