// sql server 还真是不熟悉
//看看行不行!!
select top 1 BOOK_NAME,ISSN, EXPERT_NAME,RANK,PUBLISHER,PAGE,PUBLISH_DATE ,ABSTRACT ,EXPERT_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID and (EXPERT_ID,BOOLk_ID) not in (select top 4 EXPERT_ID,BOOK_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID order by EXPERT_ID desc) order by EXPERT_ID desc //要不,
select top 1 BOOK_NAME,ISSN, EXPERT_NAME,RANK,PUBLISHER,PAGE,PUBLISH_DATE ,ABSTRACT ,EXPERT_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID and (EXPERT_ID+BOOk_ID) not in (select top 4 EXPERT_ID+BOOK_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID order by EXPERT_ID desc) order by EXPERT_ID desc
//看看行不行!!
select top 1 BOOK_NAME,ISSN, EXPERT_NAME,RANK,PUBLISHER,PAGE,PUBLISH_DATE ,ABSTRACT ,EXPERT_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID and (EXPERT_ID,BOOLk_ID) not in (select top 4 EXPERT_ID,BOOK_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID order by EXPERT_ID desc) order by EXPERT_ID desc //要不,
select top 1 BOOK_NAME,ISSN, EXPERT_NAME,RANK,PUBLISHER,PAGE,PUBLISH_DATE ,ABSTRACT ,EXPERT_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID and (EXPERT_ID+BOOk_ID) not in (select top 4 EXPERT_ID+BOOK_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID order by EXPERT_ID desc) order by EXPERT_ID desc
解决方案 »
- 问个Vector多线程问题
- swt 添加数据库记录 assertion failed: ContentViewer must have a content provider when input is set.
- 新手JDBC ORACLE的连接问题
- Jbulider 连不上 SQL SEVER2000
- 一个cache服务器的问题
- 局域网的两台机子怎么样来实现传送文件呢?
- 有没办法让HashMap的keySet()方法得到的Set顺序与put()入时的一样
- 错误 求改进
- JBuilder运行时的问题
- 请anybody1来收分
- classpath 自已的程序库位置问题?
- Java 导出 Excel文件类型问题
比如:EXPERT_ID 和BOOk_id 都只能是数字或者英数字,那么可以随便找一个其他字符比如“-”来把他们连起来就可以当做是一个域了。
你说的和我想的很象,是不是视图之类的
你能给我具体说以下吗??????????
非常感谢
建议是:
1,把复杂的sql语句分开来写,这样不仅你设计起来简单,而且会提高效率。
2,是不是可以先用相等判断,然后用not进行操作。
:我的作的是一个信息管理系统
现在是查询 我用了一个bean来做的分页
当时为了提高效率用的sql的分页,就是取出来其中的条数,比如说1-3
4—6 7-9
比如下面是取出来 第7—9个
select top 3 BOOK_NAME,ISSN, EXPERT_NAME,RANK,PUBLISHER,PAGE,PUBLISH_DATE ,ABSTRACT ,EXPERT_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID and EXPERT_ID not in (select top 6 EXPERT_ID from EXPERT,BOOK where EXPERT.EXPERT_ID = BOOK.AUTHOR_ID order by EXPERT_ID desc) order by EXPERT_ID desc 这样全部做完以后呢 ,我又发现这样只要是相同的expert_ID(相同的专家号)的都给去除了
我的是 expert_ID 和BOOK_NAME 联合做的主健
能不能用视图解决呢?!!!!实在不行的话,只能是全部取出来再找出来第多少个了55555555555555555555
非常感谢非常感谢大家
如果这两个组合起来是查询的对象的花
现在有个很奇怪的现象7条纪录
每页显示 1。条(top 1)或者2条(top 2) 或者3条(top3)的时候都是第7条记录(最后一条)显示不出来
因为主健,所以(EXPERT_ID+BOOk_ID)没有重的阿怎么回事呢
前辈救命