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

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

Question Posted / aman parihar

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

Answers were Sorted based on User's Feedback

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

Answer / jayanth

using union
select * from tableA
union
select * from tableB

Is This Answer Correct ?

0 Yes

0 No

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

Answer / 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

More SQL Server Interview Questions

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers IBM,

Do you know what is a trace frag? Where do we use it?

0 Answers

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers Cognizant, TCS,

What is tablesample?

0 Answers

Do you know what are pages and extents? : SQL Server Architecture

0 Answers

How do you open a cluster administrator?

0 Answers

Write an SQL query to obtain the 2nd highest salary.

0 Answers Akamai Technologies,

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers RBS,

What is difference between count (*) and count 1?

0 Answers

Explain the usage of floor function in sql server.

0 Answers

Can we have more than one NULL in a column having unique constraint?

12 Answers 247Customer,

List the different types of collation sensitivities in sql server?

0 Answers

For more SQL Server Interview Questions Click Here