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

2 Answers
3019 Views
Genpact, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is indexed view? How to create it?

932

List the different normalization forms?

929

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

971

Write a sql query to display the current date?

1030

How is SQL Azure different than SQL server?

223

Explain what is the purpose of sql profiler in sql server?

1011

How to optimize stored procedures in sql server?

1125

Define normalisation?

1062

Explain tablesample?

948

What is built-in/administrator?

958

What the different components in replication and what is their use?

915

Give a example to search fr a string in all stored procedure in sql server.

914

What is the process of normalising?

949

What is difference between equi join and natural join?

970

what are candidate key, alternate key and composite key? : Sql server database administration

854