排序问题,求助,扣老壳扣了几小时了,还是扣不出很合理的排序方法 select * from Users order by case when userID='xxxxxx' then Orders+1 else orders end desc , UpToffTime desc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个意思吗?declare @t table(ToffID int identity(1,1),UserId varchar(5),UserName varchar(5),Orders int,UpToffTime datetime)insert @t select 1,'1',1,getdate()insert @t select 2,'2',2,getdate()insert @t select 3,'3',3,getdate()insert @t select 4,'4',4,getdate()select * from @t--把2降到4名update @t set orders = -1 where userid = 2update @t set orders = orders - 1where orders between 3 and 4update @t set orders = 4 where userid = 2select * from @t order by orders/*ToffID UserId UserName Orders UpToffTime ----------- ------ -------- ----------- ------------------------------------------------------ 1 1 1 1 2008-03-24 18:14:21.9402 2 2 2 2008-03-24 18:14:21.9403 3 3 3 2008-03-24 18:14:21.9404 4 4 4 2008-03-24 18:14:21.940(所影响的行数为 4 行)(所影响的行数为 1 行)(所影响的行数为 2 行)(所影响的行数为 1 行)ToffID UserId UserName Orders UpToffTime ----------- ------ -------- ----------- ------------------------------------------------------ 1 1 1 1 2008-03-24 18:14:21.9403 3 3 2 2008-03-24 18:14:21.9404 4 4 3 2008-03-24 18:14:21.9402 2 2 4 2008-03-24 18:14:21.940(所影响的行数为 4 行)*/ 如何在Where语句中实现Case when? 怎样两次合计 检查个函数错误 [急]请教一个较复杂的SQL语句 该怎么写这个sql语句呀 又一个连接数据库的难题 如何设置text数据类型的初始值,其默认的长度16是什么意思,能不能改? update 问题 日前我删除了一个数据库 我的数据库怎么都打不开了?请高手指点 sql 怎么写啊? Excel中连接外部数据源问题
declare @t
table(ToffID int identity(1,1),UserId varchar(5),UserName varchar(5),Orders int,UpToffTime datetime)insert @t select 1,'1',1,getdate()
insert @t select 2,'2',2,getdate()
insert @t select 3,'3',3,getdate()
insert @t select 4,'4',4,getdate()
select * from @t--把2降到4名
update @t set orders = -1 where userid = 2
update @t set orders = orders - 1
where orders between 3 and 4
update @t set orders = 4 where userid = 2select * from @t order by orders
/*
ToffID UserId UserName Orders UpToffTime
----------- ------ -------- ----------- ------------------------------------------------------
1 1 1 1 2008-03-24 18:14:21.940
2 2 2 2 2008-03-24 18:14:21.940
3 3 3 3 2008-03-24 18:14:21.940
4 4 4 4 2008-03-24 18:14:21.940(所影响的行数为 4 行)
(所影响的行数为 1 行)
(所影响的行数为 2 行)
(所影响的行数为 1 行)ToffID UserId UserName Orders UpToffTime
----------- ------ -------- ----------- ------------------------------------------------------
1 1 1 1 2008-03-24 18:14:21.940
3 3 3 2 2008-03-24 18:14:21.940
4 4 4 3 2008-03-24 18:14:21.940
2 2 2 4 2008-03-24 18:14:21.940(所影响的行数为 4 行)
*/