摘要:
Count (*) …group by ..计算相同的栏位个数(不能用Select * 的哦)Order by ..desc/asc: 升/降排序Rownum : select的笔数(Oracle)select * from BOAT_RELATION_DTL where rownum <='100' order by RELATION_DATE ascLimit : select的笔数(MysqL)select * from BOAT_RELATION_DTL order by RELATION_DATE desc limit 100在数据库中添加新栏位 :'& 阅读全文