Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to fetch common records from two tables?

Answer Posted / mrityunjay dubey

Select column_name from tableA UNION Select column_name from tableB

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why having clause is used in sql?

1019


How do I run a query in pl sql developer?

1049


What is server name sql?

1203


What is the purpose of my sql?

1010


How can the performance of a trigger be improved?

1087


Write the command to remove all players named sachin from the players table.

1227


What are the built in functions of sql?

1092


Is it possible to sort a column using a column alias?

1098


what is try_catch block in procedure

1808


Why primary key is required?

1043


what happens if null values are involved in expressions? : Sql dba

1092


What is relationship? How many types of relationship are there?

1262


Why are sql stored procedures used?

1093


Explain aggregate functions are available there in sql?

1049


What is the difference between clustered and non-clustered indexes?

1128