Java开发网 - Re:一个解决不了的数据库查询，请高手帮助

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » Sybase

打印话题 寄给朋友 订阅主题

作者

Re:一个解决不了的数据库查询，请高手帮助 [Re:jsmile]

floater

Java Jedi

总版主

发贴: 3233
积分: 421

于 2005-01-20 00:26

not sure whether you can do this. I am not, and have never been, an DBA or SQL expert. Here is my logic: SQL is a tuple(row) based language, you are trying to make rows to columns, it's not likely. The only chance you have is that particular db may hae some functions for this.

If you are working with java, you may get the first one in SQL, and do it in java to get the second.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
- Martin Fowler, Refactoring - Improving the Design of Existing Code

话题树型展开

人气	标题	作者	字数	发贴时间
12998	一个解决不了的数据库查询，请高手帮助	jsmile	601	2005-01-19 08:18
10981	Re:一个解决不了的数据库查询，请高手帮助	jsmile	10	2005-01-19 22:11
11035	Re:一个解决不了的数据库查询，请高手帮助	floater	381	2005-01-20 00:26
11403	Re:一个解决不了的数据库查询，请高手帮助	jsmile	2066	2005-01-20 02:25
10832	Re:一个解决不了的数据库查询，请高手帮助	floater	75	2005-01-20 03:13
11012	Re:一个解决不了的数据库查询，请高手帮助	runaway	322	2005-02-04 10:50
11049	Re:一个解决不了的数据库查询，请高手帮助	jsmile	338	2005-02-04 23:31
12444	Re:一个解决不了的数据库查询，请高手帮助	liuyxit	1042	2005-03-04 15:32

已读帖子

新的帖子

被删除的帖子