在oracle中选择查询 [英] Select query in oracle

问题描述

大家好



我有一个选择查询

Hi all

I had a select query

SELECT COUNT (STATUS_FLAG) as count,
  CASE WHEN STATUS_FLAG ='Y' then 'success'
when status_flag ='I' then 'PROCESSED'
WHEN STATUS_FLAG = 'N' then 'PENDING'
END AS STATUS FROM  TABLENAME group by status_flag;

我希望结果显示列名为

I want the result to display column name as

SUCCESS        PROCESSED             PENDING
 VALUE             VALUE               VALUE.

怎么做？



Rgds

Jagadesh



SHOUTING删除 - OriginalGriff [ / edit]

How to do this?

Rgds
Jagadesh

[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案

请尝试以下查询..

Please try below query..

SELECT SUM(DECODE(STATUS_FLAG,'Y',1,0)) AS Success,
SUM(DECODE(STATUS_FLAG,'I',1,0)) AS Processed,
SUM(DECODE(STATUS_FLAG,'N',1,0)) AS Pending
FROM TableName

这篇关于在oracle中选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！