我用top n 取表中的某一部分纪录,却总是一样的结果,求解:
select top 5 resourceId,resourcename,resourceURL,resourceDescription,upPerson,[update] from Resource where resourceid not in( select top 10 resourceId from Resource where resourceDescription like '%unit%' or resourceDescription like '%unit' or resourceDescription like 'unit%' order by [update] Desc ) and
resourceDescription like '%unit%' or resourceDescription like '%unit' or resourceDescription like 'unit%' order by [update] Desc
第二个top 不管n 取5,还是10,出来的结果都一样,为什么??
select top 5 resourceId,resourcename,resourceURL,resourceDescription,upPerson,[update] from Resource where resourceid not in( select top 10 resourceId from Resource where resourceDescription like '%unit%' or resourceDescription like '%unit' or resourceDescription like 'unit%' order by [update] Desc ) and
resourceDescription like '%unit%' or resourceDescription like '%unit' or resourceDescription like 'unit%' order by [update] Desc
第二个top 不管n 取5,还是10,出来的结果都一样,为什么??
解决方案 »
- C#的一个正则
- 高分相送:在页面提交时,怎样恢复竖型滚动条的位置?
- 请问下不利用datagrid摸版,自己写个连接列,请问怎么写?有例子吗?马上结贴
- Frame3set.htm总是提示Left2.aspx第一行<%...%>出错,请问各位专家如何解决?焦急等待!
- 网页背景图片地址存在数据库里的,怎么读出来设置为背景?
- 我想在页面上实现一个树结构,各位大虾帮帮忙
- datagrid能否显示出以(image)记下sql server下的的图片!
- 在IE运行asp.net的问题
- C# 拦截器问题。
- 第1次提问,高手一定要帮助!
- GridView 排序时的下滑下可以去掉吗?如果怎么去掉!
- DataReader怎么这德行?
前5-10条select top 5 resourceId,resourcename,resourceURL,resourceDescription,upPerson,[update] from Resource where resourceid in( select top 10 resourceId from Resource where resourceDescription like '%unit%' or resourceDescription like '%unit' or resourceDescription like 'unit%' order by resourceId asc)
取前5条
select top 5 resourceId,resourcename,resourceURL,resourceDescription,upPerson,[update] from Resource where resourceDescription like '%unit%' or resourceDescription like '%unit' or resourceDescription like 'unit%' order by [update] Desc