[阅读: 263] 2005-03-23 01:08:36
select top 5 * from (
select 销售点,客户,count(*) as f1 from 销售记录表 group by 销售点,客户)
order by f1 desc
......... @@@@@ @@@@@.........
........ @ @ @ @.........
....... @@@ @ @ .........
...... @@ @ @ .........
...... @@@@@@@ @@@@@ th .......
.... ----------------------- ......
... C E N T U R Y ....
... ----------------------- ...
.. @@@@@ @@@@@ @ @ @@@@@ ..
== @ @ @ @ @ ==
__||__ @ @@@@ @ @ __||__
| | @ @ @ @ @ | |
_________|______|_____ @ @@@@@ @ @ @ _____|______|____
| -ICP -IDC -ISP |