Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Post New Answer

More SQL PLSQL Interview Questions

What are analytical functions in sql?

0 Answers  

What are different joins used in sql?

0 Answers  

what is a unique key ? : Sql dba

0 Answers  

How do I find duplicates in sql?

0 Answers  

how to get help information from the server? : Sql dba

0 Answers  




What are the Restrictions on Cursor Variables?

2 Answers  

What is pl/sql and what is it used for?

4 Answers  

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

Can we join tables without foreign key?

0 Answers  

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

For more SQL PLSQL Interview Questions Click Here
Categories