a sql question# Database - 数据库
p*m
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!
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!
