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

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

What is the advantage of sql server?

0 Answers  

What is INTVAL( )and where we use Plz any body help me

1 Answers  

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,




What is an extended Stored Procedure?

1 Answers  

What sql server means?

0 Answers  

How can sql injection be stopped? : sql server security

0 Answers  

What is index in an assignment?

0 Answers  

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

What is the difference between for xml raw and for xml auto?

0 Answers  

How to include text values in sql statements?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories