How to fetch common records from two tables?

Question Posted / gaurav kumar

How to fetch common records from two tables?..

Answer / mrityunjay dubey

Select column_name from tableA UNION Select column_name from tableB

Is This Answer Correct ?

0 Yes

0 No

More SQL PLSQL Interview Questions

Explain what is a field in a database and record in a database?

What is loop in pl sql?

What is normalization? How many normalization forms are there?

What are functions in sql?

what is unique key constraint? : Sql dba

When the mutating error will comes? and how it will be resolved?

please explain database architecture..

what are the limitations of identity column? : Transact sql

Which are sql * plus commands?

What is %type in sql?

Main diff between varray and nested tablea

how will i became good database developer?

For more SQL PLSQL Interview Questions Click Here