Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / aman parihar

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 the query and condition to delete datas in sql server.

2 Answers  

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

What do you understand by triggers?

0 Answers  

How to start and end transact-sql statements?

0 Answers  

Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,




How to update existing rows in a table?

1 Answers  

what is datawarehouse?

0 Answers   Informatica,

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

What triggers long term care?

0 Answers  

What is inner join? Explain with an example?

0 Answers  

explain different types of jions with examples briefly?

1 Answers   Zensar,

What are the differences between triggers and stored procedures?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories