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

What is trigger explain with example?

What is sql trigger example?

What is difference between table and view?

What is execute immediate?

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

Can we call dml statement in function?

what is the command line end user interface - mysql? : Sql dba

What is the command used to fetch first 5 characters of the string?

How do you write an index?

why we go for package? what are the advantages of using instead of seperate procuderes or functions

function can return multiple value?how give give sample coding

Can we create table inside stored procedure?

For more SQL PLSQL Interview Questions Click Here