[SQL]GROUP

来源：学生作业学帮网编辑：学帮网时间：2024/05/07 07:35:14

[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
两列完全相同的不同行