using union select * from tableA union select * from tableB

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

Question Posted / jayanth

Answer Posted / jayanth

using union
select * from tableA
union
select * from tableB

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can I create a new template for import ? : sql server management studio

1113

can an order by clause be used in a creation of a view?

1237

What are the basic functions for master, msdb, model, tempdb and resource databases?

1032

What are the functions in sql server?

989

What are sparse columns?

1064

What is the difference between a function and a trigger?

1122

What is normalization of database?

1177

What is global temp table?

1045

Can you explain different types of joins?

984

What is page-level compression?

1009

What do you mean by authentication modes in sql server?

1132

How to drop existing views from a database in ms sql server?

1144

How to loop through returning rows?

1085

Explain magic tables in sql server?

1100

Define outer join?

1044