User Profile

Collapse

Profile Sidebar

Collapse
harikiranjammul
harikiranjammul
Last Activity: Apr 24 '12, 07:55 AM
Joined: Nov 28 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • harikiranjammul
    replied to Query to count the rows count of one column in two tables
    in DB2
    Table 1 :


    ID1 Node_Name ID4 ID7
    10.150.3.1 SERVER5 [28/Nov/11:23:09:10 /i3-soft/com
    10.150.3.1 SERVER3 [28/Nov/11:23:09:10 /reuest-transfer
    10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /reuest-transfer
    10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /reuest-transfer
    10.150.3.1 SERVER1 [28/Nov/11:22:09:10 /reuest-transfer
    10.150.3.1 SERVER8 [28/Nov/11:23:09:10 /i3-soft/com
    10.150.3.1 SERVER1 [28/Nov/11:23:09:10...
    See more | Go to post

      Leave a comment:

    • harikiranjammul
      started a topic Query to count the rows count of one column in two tables
      in DB2

      Query to count the rows count of one column in two tables

      I need a help on SQL query.

      I have two tables RESPONSETIME00 & RESPONSETIME02, I need to count the URL’s such that how many times it was requested. I am attaching two tables & the output which I am looking for. Let me know how to get the attached output from the two tables.
      See more | Go to post
      No activity results to display
      Show More
      Working...