Sunday, 1 May 2016

TO CHECK WHETHER THE TWO TABLES HAVE THE IDENTICAL DATA OR NOT

Create Two tables with Similar Structure and same number of rows but with different values as shown below






















Now to Check Whether two tables have the Same data or not am using 'UNION'


OUTPUT:












If all the Counts are Similar then we can say that the records are identical or same, if the Count  is different then two table have different data. According to the O/P Count is not Similar, so two tables are not having the identical data.
Posted by at

5 comments:

  1. NR vinay11 June 2016 at 10:33

    Very Simple to find identical values in two tables.

    ReplyDelete
  2. python training14 October 2016 at 22:57


    thank you for imformation we are good formation
    best offer you

    ReplyDelete
  3. sathya2 November 2016 at 02:36

    It’s really amazing that we can record what our visitors do on our site. Thanks for sharing this awesome guide. I’m happy that I came across with your site this article is on point,thanks again and have a great day. Keep update more information..

    MSBI Training in Chennai

    ReplyDelete
  4. Unknown31 January 2017 at 06:19

    thanks for msbi post.. very well written you may also like this....msbi online training india

    ReplyDelete
  5. gracylayla2 April 2018 at 05:14

    Hello,
    Nice information with good content. Keep share this kind of posts. I would like to share some more interesting info about Microsoft Business Intelligence Online Training.

    ReplyDelete

Subscribe to: Post Comments (Atom)