|
|
Posted by deluca.vicente on 07/22/07 04:19
Hi,
I'm trying to build a query that get only one row from a group of
rows, but I need the values from that row and not the results of one
function group.
I need one row for each idRef, with column2=2 and the bigger column1
id |idRef | column1 | column2
1 1 0 1
2 1 1 2
3 1 2 1
4 2 0 1
5 2 1 2
6 2 2 1
7 2 3 2
For these, I will take the rows with id=2 and id=7.
Thank you, and sory for my english.
Navigation:
[Reply to this message]
|