SQL数据排序

来源：百度知道编辑：UC知道时间：2024/05/24 17:26:48

rs.Open "Select * From zbb_sun Where cid=" & cId ,conn,3,1
要按CID排序，怎么写？
Order By rId Desc 写哪？

rs.Open "Select * From zbb_sun Where cid=" & cId &" Order By rid Desc",conn,3,1

SQL顺序是
select/delete.....
where....
order by.....

delete 也有order by吗？
rs.Open "Select * From zbb_sun Where cid=" & cId &" Order By rid Desc",conn,1,1
只是读的话用上面一句就可以了