cs页面调用代码: 代码如下: public int TotalPage = 0; public int PageCurrent = 1; public int PageSize = 25; public int RowsCount = 0; string userid, username; public DataTable dt = new DataTable(); public string path, userwelcome; public string opt,cid; protec
语句: 代码如下:select * from [User] order by [Password] desc,Id asc在一个条件重复的情况下,使用第二个条件排序如下:
注意这里的第 14,15条记录(在Password相同的情况下,根据Id排序)语句: 代码如下:select top(5) * from (select top(5)* from [User] order by Id desc ) x order by [Password] asc在已经查询出来(已排序)的数据中排序(也就