没看明白,要查数据的话,楼主的已经可以了
要排序的话,因为都是按sendtime,所以没有什么要处理的
要排序的话,因为都是按sendtime,所以没有什么要处理的
解决方案 »
- 为什么我发布的帖子点击就出错呢?
- SQL语句,请帮忙!
- 为什么在已经能连接数据的代码中多添加了一行无关紧要的String代码后就不能连接数据库了?
- 未能在索引页 (1:721) 中找到 RID '16009c41fe685dd1ef1707000100050000' 的索引条目(索引 ID 0,数据库 'sdo')
- 指点:请问学delphi与学sql-server有冲突吗?
- 查询被阻塞的问题
- 请教这个SQL语句该怎么写?用DISTINCT不行啊!
- excel 如何导入数据库中
- 紧急求助,大数据库分页显示速度问题?
- 游标是动态的,请问有什么解决方案?
- SQL mail 的问题
- text类型运算的问题
SELECT distinct *
FROM tblMessageDetails
WHERE Receiver = @Username
ORDER BY SendTime Descunion allSELECT distinct *
FROM tblMessageDetails
WHERE Sender = @Username
ORDER BY SendTime Desc
@Username nvarchar(50)
AS
SELECT distinct
类型=case when Receiver=@Username then '接收' else '发送' end
,*
FROM tblMessageDetails
WHERE Receiver = @Username or Sender = @Username
ORDER BY 类型,SendTime Desc
GO
CREATE PROCEDURE spGetMessages
@Username nvarchar(50)
AS
SELECT distinct *
FROM tblMessageDetails
WHERE Receiver = @Username or Sender = @Username
ORDER BY (case when Receiver = @Username then 0 else 1 end),SendTime Desc
--接收者的排在前面
GO
或
CREATE PROCEDURE spGetMessages
@Username nvarchar(50)
AS
SELECT distinct *
FROM tblMessageDetails
WHERE Receiver = @Username or Sender = @Username
ORDER BY (case when Receiver = @Username then 1 else 0 end),SendTime Desc
--发送者的排在前面
GO