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
3034 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 blocking and how would you troubleshoot it?

3 Answers HCL,

How to filter records of table in SQL SERVER?

0 Answers Petranics Solutions,

What is conditional split?

0 Answers

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers

Explain the database you used in your final year project?

0 Answers Wipro,

What is the Control Flow in SSIS

0 Answers HCL,

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers Microsoft,

How to check if stored procedure is running in sql server?

0 Answers

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

0 Answers

What types of integrity are enforced by a foreign-key constraint

1 Answers

Which system tables contain information on privileges granted and privileges obtained

1 Answers

what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers

For more SQL Server Interview Questions Click Here