p****m
发帖数: 1 | 1 the problem:
there is a table with 2 columns a and b, a is kind of a key but there are
duplicates. Now need a sql query which will return only one record per a
value and do not care which b value is returned as long as it is one
associated with a
I have thought about it for a while, don't select a, max(b) group by a or
select distinct(a),b work in this case?
Thanks! | M*****r
发帖数: 1536 | 2 http://www.mitbbs.com/article/Database/31138452_3.html
【在 p****m 的大作中提到】
: the problem:
: there is a table with 2 columns a and b, a is kind of a key but there are
: duplicates. Now need a sql query which will return only one record per a
: value and do not care which b value is returned as long as it is one
: associated with a
: I have thought about it for a while, don't select a, max(b) group by a or
: select distinct(a),b work in this case?
: Thanks!
| b*****e
发帖数: 364 | 3 select a, max(b) group by a
Should work. |
|
