查询规则是什么?为什么C的age为空?
解决方案 »
- 急需oracle8下的oci.lib,oci.h文件,望能发给我一份
- 数据库可以连上,但执行应用程序报错 ORA-12154 TNS-12560 TNS-00530
- 请教高手?把access库中的表导入到oracle库中,用vb应该怎么办?着急!!!!!
- 存储过程编译不了?
- 天啊,怎么会出现这种情况呢,大家都来看看
- sys用户为什么不能连接呢?
- 如何复制一个表(包括结构和内容)表名不同,所在方案等等均相同
- Oracle9i里ODBC的使用?
- OPTIMIZER_MISMATCH造成的version count高的问题
- 求解SQL语句优化最佳方案
- oracle删除check约束
- oracle 更新 表数据 报sqlcode=1403
select name, decode(count(*), 2, 1, 1, null, null) age from tablename group by name;
select name, sum(age) age from tablename group by name;
with test as(
select 'a' name,'1' age from dual union all
select 'a','' from dual union all
select 'b','1' from dual union all
select 'b','' from dual union all
select 'c','1' from dual)
select name,max(age),um(age) from test group by name
查询前
code name
001
001 张三
002 李四
002
003 查询后
code name
001 张三
002 李四
003
(select '001' code, '' name from dual
union all
select '001', '张三' from dual
union all
select '002', '李四' from dual
union all
select '002', '' from dual
union all
select '003', '' from dual)
select code, max(name) from t group by code order by code你不就是上面的意思么
SELECT 'a' name ,'' age from dual union all
SELECT 'a' ,'1' from dual union all
SELECT 'b' ,'1' from dual union all
SELECT 'b' ,'' from dual union all
SELECT 'c' ,'1' from dual
) SELECT * FROM TABLE1 A where A.AGE=(SELECT MAX(AGE) FROM TABLE1 B)
楼主要的是这种?
select name, sum(age) age from tablename group by name;null值参与计算的时候,结果是null
WITH TABLE1 AS(
SELECT 'a' name ,'' age from dual
union all SELECT 'a' ,'1' from dual
union all SELECT 'b' ,'1' from dual
union all SELECT 'b' ,'' from dual
union all SELECT 'c' ,'1' from dual)
select name,max(age) from TABLE1 A group by name;