SELECT * FROM T_ARTICLE WHERE (N_ARTICLEID
in ( SELECT DISTINCT C_TITLE, N_ARTICLEID FROM T_ARTICLE GROUP BY C_TITLE,N_ARTICLEID) )
ORDER BY N_ARTICLEID DESC
解决方案 »
- 在myeclipse中导入jar包遇到的问题!!!
- 问几个关于xfire,cxf,webservice相关的问题
- Advanced Installer 制作Java web应用程序安装包
- Struts 空白页面
- JSP下来菜单问题.
- 有关于JdbcTemplate jdbc = new JdbcTemplate(dataSource)的问题
- 我想写一个简单的java程序 目的是想学习怎么使用http无状态协议下的接口
- 请问版主左边的论坛树是怎样实现的???
- weblogic中Oracle数据库连接池问题求救
- 有大神会dubbo zookeeper 吗?
- 启动项目出现:java.lang.NoClassDefFoundError: org/springframework/asm/ClassVisitor
- OScache GeneralCacheAdministrator不用spring保证内存唯一
in ( SELECT DISTINCT N_ARTICLEID FROM T_ARTICLE GROUP BY N_ARTICLEID) )
ORDER BY N_ARTICLEID DESC
in,前后的字段要对应,前面是N_ARTICLEID ,后面选择出来的必须也是N_ARTICLEID
要不然把C_TITLE去掉,要不就把它放在GROUP BY 后面
in ( SELECT DISTINCT C_TITLE, N_ARTICLEID FROM T_ARTICLE GROUP BY C_TITLE,N_ARTICLEID) )
ORDER BY N_ARTICLEID DESC
这样试下 你子查询是出来的是分组排序后不重复的两个字段的值 而你拿一个字段的值去跟两个字段的值比较肯定会出错 ,
试着把C_TITLE 去掉. SELECT * FROM T_ARTICLE WHERE (N_ARTICLEID
in ( SELECT DISTINCT N_ARTICLEID FROM T_ARTICLE GROUP BY C_TITLE,N_ARTICLEID) )
ORDER BY N_ARTICLEID DESC