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

What is the advantage of sql server?

1034

When would you use the stored procedures or functions?

1000

What is a heap?

1032

What is difference between equi join and natural join?

1038

How to create a simple table to test triggers in ms sql server?

975

Do you know how to send email from database?

1005

What is named query? : sql server analysis services, ssas

967

What is the downside of using udf?

1109

What is the default schema of your login session in ms sql server?

1049

Explain logical operators in sql server?

1105

Explain differences between web edition and business edition?

119

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

Explain the truncate command? : SQL Server Architecture

1170

How to create a local temporary stored procedure?

998

how can you attach more than 20 ldf files in sql server

2000