User Profile

Collapse

Profile Sidebar

Collapse
SanjayP
SanjayP
Last Activity: May 7 '07, 02:57 PM
Joined: Mar 1 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • SanjayP
    replied to SQL Query - distinct with 2 values
    in SQL Server
    Thanks for trying.
    But its not what I am looking for.. though its correct for my example below its not correct for the whole data I have.

    Let me re-define the data rows for a better view
    Index Name Value
    1 A 1.0 x
    1 A 2.0 x

    1 B 1.0
    1 B 2.0

    2 A 4.0 x
    2 A 5.0 x

    3 B 6.0 x
    3 B 7.0 x

    3 C 6.0
    3 C 7.0

    Whatever...
    See more | Go to post

      Leave a comment:

    • SanjayP
      started a topic SQL Query - distinct with 2 values
      in SQL Server

      SQL Query - distinct with 2 values

      I have a table defined as Table1 with rows below

      Index Name Value
      1 A 1.0 x
      1 A 2.0 x
      1 A 3.0 x

      1 B 1.0
      1 B 2.0
      1 B 3.0

      2 A 4.0 x
      2 A 5.0 x
      2 A 6.0 ...
      See more | Go to post
      No activity results to display
      Show More
      Working...