[SQL]GROUP

[SQL]GROUP
[SQL]GROUP

[SQL]GROUP
1 select * from bank_info where acctround='1' group by bankno order by bankno2 gobankno acctround
1 select * from bank_info where acctround='1' order by bankno2 gobankno acctround
1 select * from bank_info2 gobankno acctround
1 select * from bank_info where acctround='1' group by bankno,acctround order by bankno2 gobankno acctround
group by bankno,acctround的意思是找出bankno,acctround
两列完全相同的不同行