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 buffer cash and log cache in sql server?

1054

What are the advantages of user-defined functions over stored procedures in sql server?

959

Can a cursor be updated? If yes, how you can protect which columns are updated?

1029

What is replication and database mirroring?

991

How is sql server used?

907

Explain cursor as data base object?

974

What is cte (common table expression)?

977

What is precedence constraint?

923

What is use of dbcc commands?

1017

Can an automatic recovery be initiated by a user?

941

To which devices can a backup be created and where should these devices be located? : sql server management studio

968

What is row_number function?

942

What options are available to audit login activity? : sql server security

1091

What is wrong with sql server client libarary dll, ntwdblib.dll?

993

what is raid? : Sql server database administration

971