struts1 和 struts2的区别
请举通俗一点的例子来说明他们两个有着什么本质的区别 要求从struts1和struts2的详细执行过程说明。。。谢谢!!!!!
更新时间:2023-06-22 12:06
最满意答案
select decode(t.rn,1,t.单位名称) as 单位名称1 , decode(t.rn,2,t.单位名称) as 单位名称2, decode(t.rn,3,t.单位名称) as 单位名称3, from ( select c.单位名称,to_number() over(partition by c.单位名称) as rn from table1 a,table2 b,table3 c where a.id1 = b.id1 and b.id2=c.id2 ) t ; 这是在知道多少行记录数的情况下这样实现,如果不知道多少行,则最好用个中间表,搞个语句块,把相关的数先放到中间表在进行处理。
其他回答
select 字段1,字段2 from 表1 union all select 字段3,字段4 from 表1
相关问答
更多-
ORACLE行转列问题[2022-07-29]
ORACLE行转列问题 CREATE OR REPLACE PROCEDURE P_TEST IS V_SQL VARCHAR2(2000); CURSOR CURSOR_1 IS SELECT DISTINCT T.XCLCK FROM TEST T ORDER BY XCLCK; BEGIN V_SQL := 'SELECT WL,XYSL,XYCK'; FOR V_XCLCK IN CURSOR_1 LOOP V_SQL := V_SQL || ',' || 'SUM(DECODE(XCLCK,''' ... -
关于Oracle不定行转列的问题[2021-10-16]
这个要存储过程了。 CREATE OR REPLACE PROCEDURE P_TEST IS V_SQL VARCHAR2(2000); CURSOR CURSOR_1 IS SELECT DISTINCT T.XCLCK FROM TEST T ORDER BY XCLCK; BEGIN V_SQL := 'SELECT WL,XYSL,XYCK'; FOR V_XCLCK IN CURSOR_1 LOOP V_SQL := V_SQL || ',' || 'SUM(DECODE(XCLCK,''' | ... -
oracle行转列[2022-04-29]
不知道合格不? SELECT '金额' as c1, To_char (sum(decode(品名, '红', 金额, null))) AS 红, To_char (sum(decode(品名, '黄', 金额, null))) AS 黄, To_char (sum(decode(品名, '绿', 金额, null))) AS 绿 FROM TEST union all SELECT '数量' as c1, To_char (sum(decode(品名, '红', 数量, null))) AS 红, To_ ... -
Oracle 数据库行转列[2022-04-22]
create table A(名称 varchar2(10),"1月" varchar2(10),"2月" varchar2(10),"3月" varchar2(10),"4月" varchar2(10)) insert into A values ('土豆',50,60,70,80); insert into A values ('白菜',150,160,170,180); commit; select * from A; select * from ( select 名称,'1月' 月份,"1月" 值 ... -
oracle行转列问题[2021-12-23]
select c C1, sum(case when b='填充力' then d end) 填充力, sum(case when b='吸湿性' then d end) 吸湿性, sum(case when b='叶质量' then d end) 叶质量 from tablename; -
Oracle 多分组 行转列问题[2023-12-25]
select names,dt, sum(case when str1='语文' then num else 0 end) As '语文' , sum(case when str1='英语' then num else 0 end) As '英语' , sum(case when str1='数学' then num else 0 end) As '数学' , sum(case when str1='历史' then num else 0 end) As '历史' from dbtest group by ... -
oracle如何行转列[2024-03-21]
用case 这个我们学过的 我在网吧 试不了 不敢保证对 不过应该没问题把 表数据 列1 列2 列3 138079100001 a 1 138079100001 b 2 138079100001 c 3 138079100002 a 4 138079100002 b 5 SELECT 列1,MAX(CASE 列2 WHEN a THEN 列3 END), MAX(CASE 列2 WHEN b THEN 列3 END),MAX(CASE 列2 WHEN c THEN 列3 END) from 表 group ... -
oracle 行转列,列不合并[2022-10-01]
副卡列个数不确定啊,你怎么转啊,为什么不转成这样的结构呢, 主卡 副卡 A a,b,c,... B e,d.... -
oracle 列名不确定 行转列[2023-09-09]
select decode(t.rn,1,t.单位名称) as 单位名称1 , decode(t.rn,2,t.单位名称) as 单位名称2, decode(t.rn,3,t.单位名称) as 单位名称3, from ( select c.单位名称,to_number() over(partition by c.单位名称) as rn from table1 a,table2 b,table3 c where a.id1 = b.id1 and b.id2=c.id2 ) t ; 这是在知道多少行记录数的情 ... -
Oracle 多分组 行转列问题[2022-03-22]
select names,dt, sum(case when str1='语文' then num else 0 end) As '语文' , sum(case when str1='英语' then num else 0 end) As '英语' , sum(case when str1='数学' then num else 0 end) As '数学' , sum(case when str1='历史' then num else 0 end) As '历史' from dbtest group by ...