Question: I have a dataset with two columns as follows;

```
Prod Value
A    1
A    2
A    3
B    2
B    4
C    1
C    2

```

So I want all the rows where value is common for Prod, so in the example above only the following would be returned.

```
A   2
B   2
C   2 

```

Either LINQ or sql would be helpful

Thanks

Answer: 
I don't think so, there are some handy keyboard shortcuts though:

```
Fold                        ⌃⌘←      control+command+left
Fold All                    ⌘⌥⇧←     command+option+shift+left
Unfold                      ⌃⌘→      control+command+right
Unfold All                  ⌃U       control+U
Fold Methods/Functions      ⌃⌘↑      control+command+up
Unfold Methods/Functions    ⌃⌘↓      control+command+down
Fold Comment Blocks         ⌃⇧⌘↑     control+shift+command+up
Unfold Comment Blocks       ⌃⇧⌘↓     control+shift+command+down
Focus Follows Selection     ⌃⌥⌘F     control+option+command+F

```
I feel your pain. It is difficult to press cmd+option+shift+left every time I open an implementation file to collapse all the methods. I would be grateful to know of a way to set this by default. On the other hand, a probably obvious workaround may be to select the method from the method picker at the top of the window. I suppose this is how the Xcode developers intended us to find methods.. still cmd+option+shift+left is my preference.. it just hurts my hand :/