摘要: 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在数据库中添加新栏位 :'& 阅读全文
posted @ 2011-12-26 14:13 zp_Alex 阅读(226) 评论(0) 推荐(0) 编辑