[SQL]GROUP

来源：学生作业帮助网编辑：六六作业网时间：2024/11/15 12:44:40

[SQL]GROUP[SQL]GROUP[SQL]GROUP1select*frombank_infowhereacctround=''1''groupbybanknoorderbybankno2goba

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