Select column_name from tableA UNION Select column

How to fetch common records from two tables?

Question Posted / mrityunjay dubey

Answer Posted / mrityunjay dubey

Select column_name from tableA UNION Select column_name from tableB

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different operators available in sql?

747

What is normalisation in sql?

774

Explain exception handling in pl/sql?

726

What is the difference between clustered and non-clustered index in sql?

733

what is dbms? : Sql dba

735

Can you have more than one key in a database?

686

Explain how to use transactions efficiently : transact sql

716

How can one get sql*loader to commit only at the end of the load file? : aql loader

746

What is dynamic query?

732

What are the limitations of sql express?

700

What are all the different normalizations?

744

what is an alias command? : Sql dba

727

what are the advantages of sql ? : Sql dba

737

What is %s in sql?

753

what are the t string functions available in tsql? : Transact sql

735