SELECT distinct
GUID as "guid" ,
ROLE_ID as "roleId" ,
ROLEUSER_NAME as "roleuserName" ,
DEPT_CODE as "deptCode" ,
USER_NO as "userNo" ,
ROLEUSER_DEPT as "roleuserDept" ,
ROLEUSER_CREATUSER as "roleuserCreatuser" ,
ROLEUSER_CREATDATE as "roleuserCreatdate" ,
ROLEUSER_REVISEUSER as "roleuserReviseuser" ,
ROLEUSER_REVISEDATE as "roleuserRevisedate" ,
ROLEUSER_DELETUSER as "roleuserDeletuser" ,
ROLEUSER_DELETDATE as "roleuserDeletdate" ,
ROLEUSER_STATUS as "roleuserStatus"
FROM T_TSG_ROLEUSER 这样怎么去不了重复值呢?
解决方案 »
- java分布式解决方案
- struts2读取数据库问题
- ApplicationContext getBean("aduserInfoService")得不到Bean
- 关于hibernate的JDBC的查询方式问题
- ¥¥¥¥ Spring2 加载 hibernate3 sessionFactory 问题 级别:严重!!!!¥¥¥
- HIBERNATE中使用Blob插入图片
- spring+struts+Hibernate开发的系统,想在form里实现访问数据库的验证,请教~~~~~~~~
- 怎么写一个函数在应用服务器启动的时候也一起启动。因为要执行一些清理工作
- 怎样在中文客户端访问日文环境的应用程序?
- 请教spring mybatits 事物管理
- java中能生成饼状图,柱状图的控件
- java实时通信的问题
恩 你说的对,这样就没事了SELECT distinct
DEPT_CODE as "deptCode" ,
ROLEUSER_DEPT as "roleuserDept"
FROM T_TSG_ROLEUSER