Data matching

Question

hello folks! Please let me know how to do that ' Compare two tables and find only matching data and then display the result in sql server.' :)

Abhishek Jaiswal · Answer

heyy! thank u Ramesh abrar for ur kind seggestions! :)

Khan Abrar Ahmed · Answer

Hi for the count you can use below script Select count(*) from ( SELECT OrderID FROM Orders INTERSECT SELECT OrderID FROM [Order Details]) a

Ramesh Maruthi · Answer

Hey Abhishek Please use the Intersect Keyword like this between the two tables for an example i want to display the order id from two tables SELECT OrderID FROM Orders INTERSECT SELECT OrderID FROM [Order Details] this query gives the common order id's which ar exists in two tables

Abhishek Jaiswal · Answer

okay and how to count the number of rows in that table output table?