数据库设计:
ID int
Mobile varchar
Price money
JoinTime Datetime现需要查出指定日期无重复的最低出价的记录ID. 请高手帮忙解决下. 谢谢!
ID int
Mobile varchar
Price money
JoinTime Datetime现需要查出指定日期无重复的最低出价的记录ID. 请高手帮忙解决下. 谢谢!
解决方案 »
- asp.net 网页嵌入视频 web页面加载视频文件,IE兼容,不需要安装插件。
- 动态绑定数据的gridview怎么把某列变成超链接的形式?
- 关于asp.net中验证用户是否登录
- 使用repeater来实现横向排列每行4个一换行, 运行出现错误
- 总是看到URL重写这个词,一直不知道是什么意思
- 验证码失败后的处理问题
- [原创]逆向思维有时比较好.【讨论帖】
- ◆◇◆◇◆为什么 StreamWriter.Write 不能写中文?◆◇◆◇◆
- 有一字符串,如1,2,3 现要怎样把逗号的个数取出来呀?(为2)
- 关于使用B/S结构实施分布式系统的性能问题,各位请提意见。
- 求朋友一起合作发展(安徽合肥地区最好!)
- .net学习网站
WHERE Year(JoinTime)=Year(GetDate())
and Month(JoinTime)=Month(GetDate())
and Day(JoinTime)=Day(GetDate())
and Price=(SELECT top 1 Price FROM Joined
group by price,Year(JoinTime),Month(JoinTime),Day(JoinTime)
HAVING Count(Price)=1
and Year(JoinTime)=Year(GetDate())
and Month(JoinTime)=Month(GetDate())
and Day(JoinTime)=Day(GetDate())
order by price asc)结果是出来了. 不过我想应该还有更好的办法. 期待高手指点.
SELECT top 1 *
FROM Joined
WHERE datediff(day,JoinTime, GetDate()) = 0
order by price
FROM Joined
WHERE datediff(day,JoinTime, GetDate()) = 0
and price not in
(select price from joined
group by price
having count(price) > 1)order by price
FROM Joined
WHERE datediff(day,JoinTime, GetDate()) = 0
and price in
(select price from joined
datediff(day,JoinTime, GetDate()) = 0
group by price
having count(price) = 1)order by price
FROM Joined
WHERE datediff(day,JoinTime, GetDate()) = 0
and price in
(select price from joined
where datediff(day,JoinTime, GetDate()) = 0
group by price
having count(price) = 1)order by price
WHERE Datadiff(day,JoinTime,GetDate())=0
and Price=(SELECT top 1 Price FROM Joined
group by price,Datadiff(day,JoinTime,GetDate())=0
HAVING Count(Price)=1
and Datadiff(day,JoinTime,GetDate())=0
order by price asc)最后还是这么搞的. 谢谢!