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

Can we insert data if clustered index is disabled?

945

Explain data warehousing in sql server?

1054

How to delete all rows with truncate table statement in ms sql server?

1005

How can you set the threshold at which sql server will generate keysets asynchronously?

996

What is the maximum size of sql server database?

1015

What is a scheduled job or what is a scheduled task?

952

What is SQL Azure Data sync?

121

what are isolation levels? : Sql server database administration

1000

What is transaction server consistency?

1053

What is data source view or dsv? : sql server analysis services, ssas

1007

What is a coalesce function?

1201

How many types of functions are there in sql server?

948

How do triggers work?

944

What are the different types of stored procedures?

1117

Explain about sql server login?

1092